trying to sort a select statement

[kts]

Hey everyone, thanks for reading.

 

I have done this before but many moons ago. I am trying to have a few drops downs that will change the Order By clause on a Select statement. From my memory I remember you need to have the order by in a variable with a case statement to control which one it will become. I am having some trouble doing so if anyone has some sample code that they use to do this I would greatly appreciate it. I'm not sure as to why I am not able to re-create it right now, but I do not use case statements very much.

 

Thanks in advance!

[genericnumber1]

Can you show us what you're trying?

[jon23d]

How about this:

 

  // set the allowed sort fields
  $allowed_sorts = array("name", "date", "amount");
  // use the specified sort, or a default
  $sort = ($_GET['sort'], $allowed_sorts) ? $_GET['sort'] : 'name';
  // now execute the query and continue
  $rs = mysql_query("SELECT * FROM table ORDER BY $sort ASC;");