I have a table of data that I want users to be able to sort using different criteria.
I have written seperate 'form' and 'php' scripts to sort by each item in the table, but how do I combine all of these scripts into one 'php' and one 'form' script?
Example I have:
FORM SCRIPT:
<HTML>
<HEAD>
<body background="rattan.jpg">
<center>SCHEDULE SEARCH
<form method="post" action="ndokisearch.php">
DEP TIME: <input type="text" name="entry"><br>
<P>
If all information is correct, please click:
<input type="submit" name="submit" value="SUBMIT">
</form>
</html>
and the PHP Script:
<html>
<head>
<body background="rattan.jpg">
<a href="http://www.margaritaair.com/index.html">MAIN PAGE</a><P>
</html>
<?
$entry=$_POST['entry'];
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM schedule WHERE time='$entry'";
$result=mysql_query($query);
$num=mysql_numrows($result);
$date = date('j-m-y');
mysql_close();
echo "<b><h2><center>FLIGHT SCHEDULE</h2></center></b><br>";
?>
<table width="100%" bordercolor="#B8860B" bgcolor="#F0E68C" cellspacing="2" cellpadding="2" border="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">FLT #</font></th>
<th><font face="Arial, Helvetica, sans-serif">DEPARTURE</font></th>
<th><font face="Arial, Helvetica, sans-serif">DESTINATION</font></th>
<th><font face="Arial, Helvetica, sans-serif">DEPARTURE</font></th>
<th><font face="Arial, Helvetica, sans-serif">AIRCRAFT</font></th>
<th><font face="Arial, Helvetica, sans-serif">TYPE</font></th>
<th><font face="Arial, Helvetica, sans-serif">DISTANCE</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$flt=mysql_result($result,$i,"flt");
$dep=mysql_result($result,$i,"dep");
$dest=mysql_result($result,$i,"dest");
$time=mysql_result($result,$i,"time");
$plane=mysql_result($result,$i,"plane");
$type=mysql_result($result,$i,"type");
$dist=mysql_result($result,$i,"dist");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$flt"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$dep"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$dest"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$time"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$plane"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$type"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$dist"; ?></font></td>
<?
++$i;
}
echo "</table>";
