You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
61 lines
2.3 KiB
61 lines
2.3 KiB
<html>
|
|
<head>
|
|
<title>Olive Branch, MS</title>
|
|
<base target="section_body">
|
|
<link rel=stylesheet href=/styles/basic.css type=text/css>
|
|
</head>
|
|
<body>
|
|
<form method="post" action="bsearchbody.php3">
|
|
<?
|
|
// connect to the database
|
|
$connection = pg_connect("localhost", "5432", "olivebranch");
|
|
if($connection)
|
|
{
|
|
$query = "SELECT distinct category FROM member";
|
|
$result = pg_exec($connection, $query);
|
|
|
|
if($result)
|
|
{
|
|
print("Category:<br><select name=\"category\">\n");
|
|
print("<option value=\"\">--- All Categories ---\n");
|
|
for($row = 0; $row < pg_NumRows($result); $row++)
|
|
{
|
|
print("<option value=\"" . pg_result($result, $row, 0) . "\">");
|
|
print(pg_result($result, $row, 0));
|
|
print("\n");
|
|
}
|
|
|
|
pg_freeresult($result);
|
|
}
|
|
|
|
print("</select><br>\n");
|
|
|
|
pg_close($connection);
|
|
}
|
|
|
|
print("<table border=0 cellpadding=0 cellspacing=0>");
|
|
print("<tr><td colspan=2 align=left>Company Name:</td></tr>");
|
|
print("<tr><td colspan=2><input type=\"text\" name=\"wordsearch\" maxlength=32 size=17><br>\n</td></tr>");
|
|
print("<tr><td align=left><input type=\"radio\" name=\"wordoption\" value=\"start\">Starts with</td>");
|
|
print("<td align=right><input type=\"radio\" name=\"wordoption\" value=\"end\">Ends with</td></tr>");
|
|
print("<tr><td colspan=2 align=center><input type=\"radio\" checked name=\"wordoption\" value=\"contain\">Contains<br></td></tr>");
|
|
print("</table>");
|
|
|
|
print("<table border=0>");
|
|
print("<tr><td colspan=2 align=left>Contact Name:</td></tr>");
|
|
print("<tr><td colspan=2><input type=\"text\" name=\"contactsearch\" maxlength=32 size=17><br>\n</td></tr>");
|
|
print("<tr><td align=left><input type=\"radio\" name=\"contactoption\" value=\"start\">Starts with</td>");
|
|
print("<td align=right><input type=\"radio\" name=\"contactoption\" value=\"end\">Ends with</td></tr>");
|
|
print("<tr><td colspan=2 align=center><input type=\"radio\" checked name=\"contactoption\" value=\"contain\">Contains<br></td></tr>");
|
|
print("</table>");
|
|
|
|
print("<table border=0>");
|
|
print("<tr><td colspan=2 align=left>Results per Page:</td></tr>");
|
|
print("<tr><td colspan=2><input type=\"text\" value = \"5\"name=\"linesperpage\" maxlength=32 size=17><br>\n</td></tr>");
|
|
print("</table>");
|
|
?>
|
|
<input type="submit">
|
|
</p>
|
|
</form>
|
|
</body>
|
|
</html>
|