Alright, so this is what I have for the single search box and the PHP (this is all working fine):
<b>Find a musician by City:</b>
<form method="get" action="search.php">
<input type="text" name="search" size=25 maxlength=25>
<input type="Submit" name="Submit" value="Search">
</form>
<b>Results:</b><br /><br />
<?php
mysql_connect ("localhost", "SERVER", "PASSWORD") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("DATABASE") or die ('I cannot connect to the database because: ' . mysql_error());
$search=$_GET["search"];
//get the mysql and store them in $result
$result = mysql_query("SELECT * FROM listings WHERE city LIKE '%$search%'");
//grab all the content
while($r=mysql_fetch_array($result))
{
//the format is $variable = $r["nameofmysqlcolumn"];
$full_name=$r["full_name"];
$email=$r["email"];
$city=$r["city"];
$state=$r["state"];
$instrument=$r["instrument"];
$influences=$r["influences"];
$available=$r["available"];
//display the row
echo "<b>Full Name:</b> $full_name <br /><b>Email:</b> $email <br /><b>City:</b> $city, $state<br /><b>Instrument:</b> $instrument <br /><b>Influences:</b> $influences <br /><b>Available:</b> $available <br /><br />";
}
?>
What I need to do is alter this code to include the Instrument dropbox parameter in the query... It's not happening for me. I'm guessing I need a bit of HTML and some tweaking of the '$result' but I really don't know exactly what. Any re-write or clear help would be greatly appreciated.
Thanks heaps.
