Thank you very much!! :) It worked. ~WILL~ --- De Greef Sébastien <sdegreef@xxxxxxxx> wrote: > 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 > __________________________________ 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