----------------------------------- Homer_simpson Thu Aug 28, 2003 4:06 pm Reading the database backward ----------------------------------- Possible or not? if it's not possible i guess i'll have to read all the database into an array then view the array backward... here's the reason i'm doing this: http://backstabbers.no-ip.com/viewfiles.php right now it views my files from oldest to newest i need it to be from newest to olders... ----------------------------------- Amailer Thu Aug 28, 2003 4:59 pm ----------------------------------- use order by DESC or ASC i.e: SELECT * FROM table_name ORDER BY name DESC; ----------------------------------- Homer_simpson Thu Aug 28, 2003 9:02 pm ----------------------------------- +10 bits TY ----------------------------------- Amailer Fri Aug 29, 2003 11:08 am ----------------------------------- np thx