sort links by date with PHP ?

[Alessandro]

hi ,
I need a script that sorts my links (thumbs + text) by date .
Anyone knows a good one ?

[ppk]

What format is the raw data in?

[Alessandro]

Originally posted by ppk
What format is the raw data in?

can you ICQ me ? #132818937

[pornanza]

SELECT title, url FROM links ORDER BY date DESC;

ryan

[wsjb78]

Originally posted by pornanza
SELECT title, url FROM links ORDER BY date DESC;

ryan

And for entering the date:

$time_now = mkdate();
$sql = "INSERT INTO link SET title='$title', url='$url', date='$time_now'";
if(mysql_query($sql) {
  echo "New link successfully added";
} else {
  echo "Could not add new link";
} 

[assistant27]

....

[hyper]

select * from table order by date desc