selecting the most recent.

[pheagey]

Ok, I have adb with a list of files. How canI select only the most recent by date?
Here's the line I have right now:

$sqlDIDList = mysql_query("SELECT * FROM dl_links WHERE categoryid=$id AND approved=1 ORDER BY date DESC");

when I echo it I get an error like:

Resource id #(number)

I know the answer is right in ront of me. Imust be havong a brain block...

[jek]

Not really sure If I understand correctly, but try this:

$sqlDIDList = mysql_query(" SELECT * FROM dl_links WHERE categoryid="$id" AND approved="1" ORDER BY date DESC LIMIT 1 ") or die("SELECT Error: ".mysql_error());

If this doesn't solve it, please post your entire script.