<html>
<body>
<form method="get" action="search.php">
<?php
$DbConn = mysql_connect("localhost", "*", "*" ) or die(mysql_error());
mysql_select_db("ingestate",$DbConn) or die("Can Not Select DataBase Because: ".
mysql_error());
$sql = "SELECT terminal.signature , terminal.name , terminal.parent_id
FROM calls,terminal
WHERE calls.terminal_id=terminal.terminal_id";
$SearchResult = mysql_query($sql) or die(mysql_error(). "<br />SQL: ". $sql);
$TotalResults = mysql_num_rows($SearchResult);
mysql_close();
?>
<table border="1" cellspacing="2" cellpadding="2" >
<tr>
<th><font face="Arial, Helvetica, sans-serif">Value1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value3</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value4</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value5</font></th>
</tr>
<?php
$i=0;
while ($i < $TotalResults) {
$f1 = mysql_result($SearchResult, $i,"SIGNATURE");
$f2 = mysql_result($SearchResult, $i,"NAME");
$f3 = mysql_result($SearchResult, $i,"PARENT_ID");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
</tr>
<?php
$i++;
}
?>
</form>
</body>
</html>
