Re: Order By........
| From: | De Greef S�bastien | Date: | Tue, 27 Apr 2004 08:16:56 +0000 |
| Subject: | Re: Order By........ | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23558@lists.php.net to get a copy of this message | ||
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@yahoo.com> a écrit dans le message news:
20040427011646.63635.qmail@web60105.mail.yahoo.com...
> 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