RichGags Posted April 2, 2009 Share Posted April 2, 2009 I set up a results page which shows me results from my query... $query_WADAproperties = "SELECT id, pic, address, city, state, submarket, type, class, year, buildingsize, floorsize, space, broker, annualrent FROM properties ORDER BY id ASC"; How would I set up the ORDER BY to be a variable so when I click on a column heading on the results page it passes the variable to the php and re-sorts it? I would think that I need to declare a variable that defaults to "id" if nothing is passed to it and put it somewhere .... and make the headings clickable, pointing back to the results.php with a parameter, but have no idea how. Thanks! Rich Link to comment https://forums.phpfreaks.com/topic/152156-how-do-i-order-by-a-variable/ Share on other sites More sharing options...
Andy-H Posted April 2, 2009 Share Posted April 2, 2009 try this: $order_by = isSet($_GET['order_by']) ? mysql_real_escape_string($_GET['order_by']) : 'id'; $query_WADAproperties = "SELECT id, pic, address, city, state, submarket, type, class, year, buildingsize, floorsize, space, broker, annualrent FROM properties ORDER BY " . $order_by . " ASC"; //blah... <th><a href="?order_by=pic">Pic</a></th> <!--- Blahhhh... --> Link to comment https://forums.phpfreaks.com/topic/152156-how-do-i-order-by-a-variable/#findComment-799132 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.