This is my current sql query which catches in desc order for dateposted and list only 10 sql data.
select dateposted, filename, description from datafiles where office = 'AC/PA' order by dateposted desc limit 10";
This will probably work fine. Anyway, make sure that "dateposted" has DATE field format. Otherwise sorting will probably take much longer and can sometimes have strange effects ;)
Fred
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
