Re: switch field order
| From: | Haseeb Iqbal | Date: | Tue, 22 Apr 2003 18:58:48 +0000 |
| Subject: | Re: switch field order | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144771@lists.php.net to get a copy of this message | ||
this will help
$strQuery="SELECT * FROM tblName WHERE somecondition ORDER BY fieldName
".(($IsDesc==1)?" DESC":"");
<a href="pagename.php?IsDesc=1">Desc</a><a
href="pagename.php?IsDesc=0">ASC</a>
Creativity is inventing, experimenting, growing, taking risks, breaking
rules, making mistakes, and having fun.
Haseeb Iqbal
----- Original Message -----
From: "daniel" <daniel@electroteque.org>
To: "PHP General" <php-general@lists.php.net>
Sent: Tuesday, April 22, 2003 11:44 AM
Subject: [PHP] switch field order
> hi there , i am trying to work out how to switch certain field orders
either
> ASC or DESC from mysql , from links , so when i have click a link to be in
one
> sort order it will switch to go to another sort order, let me know thanks.
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>