Hi,
thanks for helping me. i got the solution.
I altered this query it is working fine.
Thanks for u r help
chand basha
Last Activity: Sep 29 '11, 11:20 AM
Joined: Aug 23 '11
Location:
-
how to delete duplicate rows and keep the origianal rows in mysql
Hi,
how can i delete the duplicate rows and keep the original row in the mysql date.
rs = "select count(email) as mail from import_address_ book group by email having mail > 1
rs.each do |mail|
`delete from import_address_ book where email limit #{mail - 1}";
end..
please can any correct it and send me the executing query... -
select data from server one and insert it into server two
Hi,
I have two servers. The question is i want to select the information form one server's table and insert it into other server's table. for that how many files i need.
I am able to select table data form server one but i don't know how to insert it into server two's table.
can any one help me or give me brief idea which will work -
Hi,
Thanks for reply. I got solution.Leave a comment:
-
how to download html table in excel format in php
Hi,
i am displaying mysql data in html table.
How can i download it in msexcel format by using php. I am using pagination also. The download should be complete table. -
thanks for reply but my date is coming with html tags also so it is not taking.....i have taken substr and explode it and i now getting only the date....
ok problem solved.....Leave a comment:
-
how to set default date in mysql query
Hi,
Can any one tell me how to set the default date in mysql query.
i have some date base in that i need to run crone every day.
But i need to run the crone only for this month.
for ex i need to start running the crone from 1st august onwards........ . -
how to pick date from datetime format
hi,
how to take only date from 2011-08-24 16:12 this timestamp. -
thank for ur suggestionLeave a comment:
-
hi,
i got the concept, how to convert it to plain text with out tagsLeave a comment:
-
how to get values from a html table
hi,
how do i get the current status and delivered data from this page.
http://trackntrace.afl wiz.com/aflwizhtmltrack ?shpntnum=84252 622306407166 -
how to get values from html page
hi,
i have one page can any one tell me how to pull current status form this file.
http://trackntrace.afl wiz.com/aflwizhtmltrack ?shpntnum=84252 622306407166
No activity results to display
Leave a comment: