Hello I could use some help, I would like to be able for a viewer to click on (Description Location Deadline) and have it sort, I can't get it to work, any help would be greatly appreciated. Thank You
http://www.darlington.k12.sc.us/dcsd...ment/oview.php
<?php
$query = "SELECT id, location, description, syear FROM teacher ORDER BY description;";
$result = mysql_query($query,$link);
print "<table border=\"1\">";
print "\t<b><tr><td>Description</td><td>Location</td><td>School Year</td></tr><tr></b>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
print "\t\t<td><font size=\"-1\"><a href=\"tpopup.php?id=$line[id]\" target=\"_blank\">$line[description]</a></td>\n";
print "\t\t<td><font size=\"-1\"><a href=\"http://www.darlington.k12.sc.us/dcsdweb/general/Location/location.html\" target=\"_blank\">$line[location]</a></td>\n";
print "\t\t<td><font size=\"-1\">$line[syear]</a></td>\n";
print "\t</tr>\n";
}
print "</table>\n";
?>
http://www.darlington.k12.sc.us/dcsd...ment/oview.php
<?php
$query = "SELECT id, location, description, syear FROM teacher ORDER BY description;";
$result = mysql_query($query,$link);
print "<table border=\"1\">";
print "\t<b><tr><td>Description</td><td>Location</td><td>School Year</td></tr><tr></b>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
print "\t\t<td><font size=\"-1\"><a href=\"tpopup.php?id=$line[id]\" target=\"_blank\">$line[description]</a></td>\n";
print "\t\t<td><font size=\"-1\"><a href=\"http://www.darlington.k12.sc.us/dcsdweb/general/Location/location.html\" target=\"_blank\">$line[location]</a></td>\n";
print "\t\t<td><font size=\"-1\">$line[syear]</a></td>\n";
print "\t</tr>\n";
}
print "</table>\n";
?>
Comment