RE: [PHP-WIN] Order By........
| From: | Gryffyn, Trevor | Date: | Thu, 29 Apr 2004 13:28:11 +0000 |
| Subject: | RE: [PHP-WIN] Order By........ | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-23591@lists.php.net to get a copy of this message | ||
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@yahoo.com]
> Sent: Monday, April 26, 2004 9:17 PM
> To: PHP-Windows
> Subject: [PHP-WIN] 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
>
>