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 Quote 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... --> Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.