my question is about sql select order by

i am displaying the value of date variable in a page and in the sql query i have given ORDER BY DESC so that the latest date will appear at the top followed by older in a reverse order following is the code

$date = date("l dS \ F Y h:i:s A");

insert into stats (date) values('$date');

$con = mysql_connect("localhost","username","password");

if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("database", $con);

$sql="select * from stats ORDER BY date DESC";

$sql_result=mysql_query($sql,$con) or exit("Sql Error ".mysql_error());

$sql_num=mysql_num_rows($sql_result);

while($sql_row=mysql_fetch_array($sql_result))
{
$date_sqlquery=$sql_row["date"];

echo "<p>Date = ".$date_sqlquery."</p>";
}

mysql_close($con);


the field type = varchar(100) in the database

how change i change the sql select query so that i can get the latest date value to be printed in a reverse order along with displaying other fields from the stats table

thanks

You should add a field 'time_created' type int store mktime() data. Order by with time_created.

i have created a field called date1 and under TYPE from phpmyadmin there are
DATE, DATETIME, TIMESTAMP,TIME,YEAR which of these should i select and i have set the length to 100

in the php the date variable is stored as
$date = date('l jS \of F Y h:i:s A');

choose DATETIME in mysql and in PHP

the date format shall be

$date = date("Y:m:d:h:s:i");

for a created date, it should be a TIMESTAMP, and the DEFAULT should be set to CURRENT_TIMESTAMP (there's an option on phpMyAdmin for that)

In phpmyadmin you also have attributes, and if you set that field to "on update CURRENT_TIMESTAMP", whenever you run a query on that row, timestamp will auto update, otherwise leave it blank.