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





mysql_query("INSERT INTO logdisplay VALUES('$ID','$column1','$Timestamp','$column2','$ columns3')");





$affected_rows = $sql->a_rows;





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



select * from logdisplay order by Timestamp





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

First you need to use either DATETIME or TIMESTAMP types on that field in the db. These are stored in number only formats (with a delimeter). Text Types will just order as if it is a string. See here (http://dev.mysql.com/doc/refman/5.0/en/datetime.html) for a list of aceptibable formats. Use php to do any formating you would like on the page.


sorting rows (http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html)
SELECT * FROM logdisplay ORDER BY Timestamp DESC

Got it in order, let me know....