using a url to change display order?

Codewalkers Forums Sponsor:

August 30th, 2002, 01:47 AM

Scurvy

Join Date: Apr 2007

Location: Ormond Beach, FL USA

Posts: 26

Time spent in forums: < 1 sec
Reputation Power: 0

using a url to change display order?

Hello again all. I'm back with another query for the guru's. Not sure if this is php or html ? but here goes

I have my db output as such:

name | age | dob
bob | 14 | whatever
tom | 21 | whatever
etc.

I'd like to have 'name' and 'age' be links to show the same info but ordered by 'name' or 'age'.
Can this be done in the url as in:
www.mydomain.com/ages.php?ORDERBY=age

I tried several similar strings but nothing works. Just refreshes the current page.
Without making a separate php page with the different order by queries is this possible and if so, what's the proper syntax?

Thanks for any info
Scurvy

August 30th, 2002, 02:13 AM

Matt

Moderator

Codewalkers Specialist (4000 - 4499 posts)

Join Date: Apr 2007

Location: Florida

Posts: 4,158

Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6

RE: using a url to change display order?

You could do something like this....

php Code:

Original - php Code
<? if(!isset($_GET['ORDERBY']) { /* set default ordering if nothing in url / $orderby = 'name'; } else { / make sure no bogus info is passed / $valid = array('name','age'); if (in_array($_GET['ORDERBY'],$valid) { $orderby = $_GET['ORDERBY']; } else { $orderby = 'name'; } } $query = "SELECT name,age,dob FROM yourtable ORDER BY $orderby"; / now on to the rest of your code as normal. */ ?>

<?
if(!isset($_GET['ORDERBY']) {
  /* set default ordering if nothing in url */
  $orderby = 'name';
} else {
  /* make sure no bogus info is passed */
  $valid = array('name','age');
  if (in_array($_GET['ORDERBY'],$valid) {
    $orderby = $_GET['ORDERBY'];
  } else {
    $orderby = 'name';
  }
}
$query = "SELECT name,age,dob FROM yourtable ORDER BY $orderby";
 
/* now on to the rest of your code as normal. */
?>

Viewing: Codewalkers Forums > PHP Related > PHP Coding > using a url to change display order?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump