Monday, October 26, 2009

iPhone dev Stupidity 88: SQL reverse ordering

Using DESC:

SELECT #fieldlist# FROM EmailData 
ORDER BY DateSent DESC

1 comment:

Sara Reid said...

i'm currently using this:
SELECT * FROM files_art order by $srt limit $offset,$showamnt
where the vars are user defined
would using this:
SELECT * FROM files_art order by $srt desc limit $offset,$showamnt
work then?

creatine