If you want the last post first, you probably want to order your query "descending", try this line: $get_post = "select * from $table_name2 where cat_id = '$_POST[cat_id]' ORDER BY posted DESC"; -TG > -----Original Message----- > From: Will [mailto:will8766@xxxxxxxxx] > Sent: Monday, April 26, 2004 9:17 PM > To: PHP-Windows > Subject: Order By........ > > > 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 > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
