Let's see:
<?
$dir = ((isset ($_GET['dir'])) ? (int) $_GET['dir'] : 1);
if (!$dir)
$direction = 'desc';
$dir = ($dir ? 0 : 1);
?>
<td><a href="default2.php?orderBy=<?=$colname?>&dir=<?= $dir?>">Last
Name</a></td>
This is the general idea. $dir will toggle between 1 and 0. There are
more "compact" ways of writing this--but this one should be clearer.
Marco
-------------
php|architect -- The Monthly Magazine For PHP Professionals
Come visit us on the web at http://www.phparch.com!
On Fri, 2002-11-08 at 10:04, Paul Ihrig wrote:
> Hello All!
> i am new to the list & to PHP..
>
>
> So i have a recordset that displays my contacts in a table.
> the headers of the columns look like this.
>
> <td><a href="default2.php?orderBy=priLastName">Last Name</a></td>
>
> so when a user clicks on it
> It will Re-Sort the rs by priLastName Asc.
>
> what i want to do is make it a toggle
> between table name ASC or DESC..
>
> any ideas?
> thanks.
>
> -paul
>
> #$orderBy = 'priFirstName';
>
> $orderBy = 'priLastName';
> if (isset($HTTP_GET_VARS['orderBy'])) {
> $orderBy = $HTTP_GET_VARS['orderBy'];
> }
> #?orderBy=priFirstName
>
> $maxRows_rsAll = 5;;
> $pageNum_rsAll = 0;
> if (isset($HTTP_GET_VARS['pageNum_rsAll'])) {
> $pageNum_rsAll = $HTTP_GET_VARS['pageNum_rsAll'];
> }
> $startRow_rsAll = $pageNum_rsAll * $maxRows_rsAll;
>
> mysql_select_db($database_myFirstSql, $myFirstSql);
> $query_rsAll = "SELECT * FROM userinfo ORDER BY $orderBy ASC";
> $query_limit_rsAll = sprintf("%s LIMIT %d, %d", $query_rsAll,
> $startRow_rsAll, $maxRows_rsAll);
> $rsAll = mysql_query($query_limit_rsAll, $myFirstSql) or die(mysql_error());
> $row_rsAll = mysql_fetch_assoc($rsAll);
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
