MySQL Sortable HTML Table

Anon

Are sortable tables inherently a monster to write? (PHP->MySQL)

I am trying to figure it out (for the first PHP script I have ever written) and the only way I see of doing it is changing the variables submitted in the original query into a variable (newsort or something) that contains \"?number=$number&?model=$model\" etc etc etc... and then during the print <thead><tr><td>backto.php$newsort

Then that would submit itself to do a whole new query with the variable for ORDER by being switched with whatever column was clicked on. Now I don\'t know how to determine which column was clicked on without sending a hidden value that would make the script that much more complex.

There has to be an easier way. Any examples anyone?

garrethkelly

Cameron,
here is a simple script
hope it helps it is from my site www.limerickchessclub.com

what i normally do is have the database part in a differnt script and use the include statement .

here it is , comment if you want
<?

Please edit the password to reflect the one you created for your database

$host = "localhost";
$database = "yourdb";

$conn = @mysql_connect($host, $database, "password") or die ("Unable to connect to database.");

mysql_select_db($database) or die ("Unable to select database.");

echo "<title>Links</title><body bgcolor=\"#FFCC33\"><div align=\"center\">";

echo "<table width=\"100%\" border=\"0\" height=\"75\">";
echo "<tr><td bgcolor=\"#6699CC\" width=\"14%\" height=\"58\"> </td>";
echo "<td bgcolor=\"#FFCC33\" width=\"72%\" height=\"58\">";
echo "<div align=\"center\">";
echo "<p><font size=\"4\"><b>=====Links=====</b></font></p></div><ul>";

$query = "Select * from links ORDER BY lDesc ";

$query_result_handle = mysql_query ($query);
for ($count = 1; $row = mysql_fetch_array ($query_result_handle); ++$count)
{
$xr1 = $row[0];
$xr2 = $row[1];
echo "<li><b><div align=\"left\"><a href=\"";
echo $xr2;
echo "\">";
echo $xr1;
echo "</a></div></li>";
}
echo "</ul></td><td bgcolor=\"#6699CC\" width=\"14%\" height=\"58\">";
echo "<div align=\"center\">";
echo "<p> </p></div></td></tr></table></div>";
?>