Re: [PHP-DB] Order DB through url toggle
Let's see:
?
$dir = ((isset ($_GET['dir'])) ? (int) $_GET['dir'] : 1);
if (!$dir)
$direction = 'desc';
$dir = ($dir ? 0 : 1);
?
tda 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.
tda href=default2.php?orderBy=priLastNameLast 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
RE: [PHP-DB] Order DB through url toggle
well i tried that..
but it out puts the right number.
but it is not taking that var to switch ACS or DESC...
http://localhost/php/default2.php?orderBy=priLastNamedir=0
http://localhost/php/default2.php?orderBy=priLastNamedir=1
/* here we set up out order by clause */
$orderBy = 'priLastName';
if (isset($HTTP_GET_VARS['orderBy'])) {
$orderBy = $HTTP_GET_VARS['orderBy'];
}
/* and the desc asc */
if $HTTP_GET_VARS['dir'] = 0 {
$diri = 'DESC';
} else {
$diri = 'ASC';
}
mysql_select_db($database_myFirstSql, $myFirstSql);
$query_rsAll = SELECT * FROM userinfo ORDER BY $orderBy $diri;
$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);
Then
?
$dir = ((isset ($_GET['dir'])) ? (int) $_GET['dir'] : 1);
if (!$dir)
$direction = 'desc';
$dir = ($dir ? 0 : 1);
?
tda href=default2.php?orderBy=priLastNamedir=?= $dir?Last
Name/a/td
tda href=default2.php?orderBy=priPhonePhone/a/td
tda href=default2.php?orderBy=priEmailEmail/a/td
tda href=default2.php?orderBy=priStreetStreet/a/td
tda href=default2.php?orderBy=priCityCity/a/td
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Order DB through url toggle
On Saturday 09 November 2002 00:26, Paul Ihrig wrote:
well i tried that..
but it out puts the right number.
but it is not taking that var to switch ACS or DESC...
http://localhost/php/default2.php?orderBy=priLastNamedir=0
http://localhost/php/default2.php?orderBy=priLastNamedir=1
/* here we set up out order by clause */
$orderBy = 'priLastName';
if (isset($HTTP_GET_VARS['orderBy'])) {
$orderBy = $HTTP_GET_VARS['orderBy'];
}
/* and the desc asc */
if $HTTP_GET_VARS['dir'] = 0 {
Try:
if $HTTP_GET_VARS['dir'] == 0 {
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Thank God a million billion times you live in Texas.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Order DB through url toggle
I think you might be missing a = sign in your if statement.
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 11:26, Paul Ihrig wrote:
well i tried that..
but it out puts the right number.
but it is not taking that var to switch ACS or DESC...
http://localhost/php/default2.php?orderBy=priLastNamedir=0
http://localhost/php/default2.php?orderBy=priLastNamedir=1
/* here we set up out order by clause */
$orderBy = 'priLastName';
if (isset($HTTP_GET_VARS['orderBy'])) {
$orderBy = $HTTP_GET_VARS['orderBy'];
}
/* and the desc asc */
if $HTTP_GET_VARS['dir'] = 0 {
$diri = 'DESC';
} else {
$diri = 'ASC';
}
mysql_select_db($database_myFirstSql, $myFirstSql);
$query_rsAll = SELECT * FROM userinfo ORDER BY $orderBy $diri;
$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);
Then
?
$dir = ((isset ($_GET['dir'])) ? (int) $_GET['dir'] : 1);
if (!$dir)
$direction = 'desc';
$dir = ($dir ? 0 : 1);
?
tda href=default2.php?orderBy=priLastNamedir=?= $dir?Last
Name/a/td
tda href=default2.php?orderBy=priPhonePhone/a/td
tda href=default2.php?orderBy=priEmailEmail/a/td
tda href=default2.php?orderBy=priStreetStreet/a/td
tda href=default2.php?orderBy=priCityCity/a/td
--
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
RE: [PHP-DB] Order DB through url toggle
Thanks Guys..
This seemed to do the trick
/* and the desc asc */
$dir = ((isset ($_GET['dir'])) ? (int) $_GET['dir'] : 1);
if (!$dir)
$dir = ($dir ? 0 : 1);
if ($HTTP_GET_VARS['dir'] == 0) {
$diri = 'DESC';
}
if ($HTTP_GET_VARS['dir'] == 1) {
$diri = 'ASC';
}
mysql_select_db($database_myFirstSql, $myFirstSql);
$query_rsAll = SELECT * FROM userinfo ORDER BY $orderBy $diri;
-paul
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
