Hi all.I use $Timestamp=date("g:i A l, F j Y."); to collect time and date the visitors entered my site . It inserts the data in to mysql database in this format :



3:02 AM Monday, July 24 2006









But when i query the database and use order by ,the data does not get displaied in order of newest on the top!!







could any one help me so that i get newst log records on the top .In another how to query my table baced on time an data.Thanks

The "desc" SQL keyword causes the query results to be sorted in descending order:

select * from logdisplay order by Timestamp desc

Jon Emerson
http://www.jonemerson.net/

i do not think that gona works since my the column that has both
date and time is stored as char like this :3:02 AM Monday, July 24 2006

Haha that's not exactly a great database design, is it? I'd strongly encourage you to improve it by using a timestamp or a date column instead. In fact, you can add one very simply by simply adding a new timestamp column at the end of your table. MySQL will automatically set this timestamp value to the current time every time the row is updated. Since this appears to be a log table, each row will only be written to once, and therefore the new column will be the insertion date.

If you're serious about keeping your current design, there's still hope for you :). You can use MySQL's STR_TO_DATE function to convert the date string to a proper timestamp inside your query. A rough undebugged example would be:

select * from logdisplay order by STR_TO_DATE(Timestamp, "%l:%i %p %W, %M %e %Y")

For more information on date format conversion in MySQL, go here: http://dev.mysql.com/doc/refman/5.0/...functions.html

If you're not using MySQL, other database servers should provide equivalent functions.


Jon Emerson
http://www.jonemerson.net/