you must add the Order like ASC for upwards and DESC for descending order "select * from $table_name2 where cat_id = > '$_POST[cat_id]' ORDER BY posted DESC"; DESC will show from the last to the fiirst post from today to last week.... Regards "Will" <will8766@xxxxxxxxx> a écrit dans le message news: 20040427011646.63635.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxx > Hello All, > I have a question regarding the order by: > > Here is my code: > $get_post = "select * from $table_name2 where cat_id = > '$_POST[cat_id]' ORDER BY posted"; > > It is not taking the last post and putting it first. I > think there is something else I have to put there but > I cannot figure it out. Can someone help. > > > > > __________________________________ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
