Sort By Columns Help

[Darin]

I need some help creating links that sort the table by the column that the person clicked on. For example if you do a search on Cnet.com in the downloads section, you can click on the name, date, size, etc... to sort them by that.

How would I go about doing that in my columns? Is there a fixed link, that I just need to edit to suit my needs?

Any help would be greatly appreciated!

[TWTCommish]

It's usually sort of like this (rough, non-working example):

<?php
  if ($sort == "name") {
    $field = "username";
  } else if ($sort == "date") {
    $field = "date";
  } else {
    $field = "title";
  }

$result = mysql_result("SELECT blah FROM table WHERE blah ORDER BY $field DESC");

That's the basic logic behind it. You pass the field to sort by (or a word that lets you know what field to sort by) in the URL with the link, and modify your query accordingly.