I could put the forms online but at this time the database is not on a public server.
below is the page with both forms, followed by the action scripts... I can take either form/script and put it on a page of its own and they both work
----------------------------------------------------------------------
<body>
<table width="98%" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td width="34%" height="67" rowspan="2">
<h2> </h2>
</td>
<td width="29%" height="67" rowspan="2">
<table width="223" height="65" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="223" height="63" valign="top">
<form action=searchform2.php method=post>
<font size="4"><b> Search a City &<br>
Business Category: </b></font>
<table width="214">
<tbody>
<tr>
<td valign="top">
<select name=city>
<option value="" selected>New York
<option>Los Angeles
<option>Miami
</select>
<br>
<select name=category>
<option selected>Television
<option>Print
<option>Radio
<option>www
</select>
</td>
</tr>
</tbody>
</table>
<input type=submit value=search name=submit>
</form>
</table>
</td>
<td width="19%" height="3">
<div align="center">
<p><font size="2"><br>
<script language="javascript" type="text/javascript">
function checkInput()
// verify that the user input some data before submission
{
var searchTerm = document.forms.searchForm.searchTerm.value;
if (searchTerm == "")
{
alert("You did not enter a name to search for, please try again.");
return false;
} else {
return true;
}
}
</script>
</font></p>
</div>
</td>
<td width="18%" height="67" rowspan="2">
<div align="center"><font size="2"><br>
<br>
<br>
</font></div>
</td>
</tr>
<tr valign="top">
<td width="19%" height="105">
<div align="center">
<form name="searchForm" action="searchform1.php" method="post">
<font size="4"><strong>Search by Name</strong></font>:
<input type="text" name="searchTerm" size="25" maxlength="45">
<input name="submit2" type="submit" value="Search">
</form>
----------------------------------------------------------------------//searchform2.php
//this can be used as a stand alone application
<body>
<p><a href="javascript:history.go(-1);">Go back</a></p>
<p>
<?php
/*
broke this into functions...much easier to see and follow the flow of the program
*/
/* main code block */
//see if the form is submitted
if (!$_POST['submit']){
show_form();
}else{
//form submitted and need to get record(s)
get_data();
}//end if
//end main code block
function show_form()
{
//assume that city and category come from database
(connection data removed for space)
//get data for city and category
$sql = 'SELECT DISTINCT city FROM bus_list ORDER BY city';
$r = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_object($r))
{
$city[] = $row->city;
}
$sql = 'SELECT DISTINCT category FROM bus_list';
$r = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_object($r))
{
$category[] = $row->category;
}
$result_city = mysql_query($sql) or die ("Can't connect to perform query one because ".mysql_error());
$result_category = mysql_query($sql) or die ("Can't connect to perform query two because ".mysql_error());
if ((!result_city)||(!$result_category)){
echo "error retrieving data";
}else{
//place the results into an array
while ($rows=mysql_fetch_array($result_city )){
$city[]=$rows['city'];
}
//while ($rows1=mysql_fetch_array($result_category)){
//$category[]=$rows1['category'];
//}
//show the form headers
echo "
<body>
<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\">
<table>
<tr>
<td>Select city</td></td>
<td>Select category</td>
</tr>
<tr>
<td><select name=\"city\">";
//show the city data
for ($x=0;$x<count($city);$x++){
echo "<option value=\"".$city[$x]."\">".$city[$x];
}
echo "</select></td><td>
<select name=\"category\">";
//add the category data
for ($x=0;$x<count($category);$x++){
echo "<option value=\"".$category[$x]."\">".$category[$x];
}
echo "</select></td></tr></table>
<input type=\"submit\" name=\"submit\" value=\"search\">
</form></body>";
}
}//end function show_form
function get_data()
{
//get data from form
$city=$_POST['city'];
$category=$_POST['category'];
$sql="select * from bus_list where city='$city' and category='$category' ORDER BY name";
mysql_connect("localhost", "#######", "#######") or die(mysql_error());
mysql_select_db("BUSLIST") or die(mysql_error());
$result=mysql_query($sql) or die ("can;t query because ".mysql_error());
echo "<div align=\"center\">\n";
echo "<table border=\"0\" cellspacing=\"6\" cellpadding=\"0\" width=\"90%\" >" ;
$a = 2;
while ($row=mysql_fetch_array($result)) {
if ($a%2 == 0) {
$bg = "#FFFFFF";
} else {
$bg = "#99FFCC";
}
echo"<tr bgcolor=\"".$bg."\"><td><img src=favicon.ico border=0></td><td>".$row['name']."</td><td>".$row['address']."</td><td>".$row['city']."</td><td>".$row['phone']."</td><td>".$row['www']."</td><td>";
$a++;
}
echo "</table>";
//show results to user
}
//end function get_data
?>
--------------------------------------------------------------------
searchform1 to follow in next msg.