Hello,
I'm trying to create a search function with two fields, a dropdown and a text box. For example, from the dropdown I select a skill, and from the texbox I enter a City. So I am searching for this specific skill in this specific city.
I can search by skill, though the city is having a rough time. Could someone please tell me where I have errored here?

Thanks very Much!
_____________________________________________________
<?php
// Connect to database
include_once "scripts/connect_to_mysql.php";


if (isset($_POST['Submit'])) {

$queryString = "WHERE email_activated='1' ORDER BY id DESC";
$queryMsg = "Showing Members by City and Skill";

} else if (($_POST['listByq'] == "newest_members"))

$queryString = "WHERE email_activated='1' ORDER BY id DESC";
$queryMsg = "";

/////////////// Set up Skill Variable
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if(isset($skill)) {

$skilled .= "$skill";

}

if(isset($skill2 )) {

$skilled .= "$skill2";

}
/////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////

$skilled = $_POST['skilled'];
$zip = $_POST['zip'];


////////////// QUERY THE MEMBER INFORMATION
$sql = mysql_query("SELECT id, firstname, city, zip, skill, skill2 FROM myMembers WHERE skill LIKE '%".$skilled."%' OR skill2 LIKE '%".$skilled."%' AND zip LIKE '%".$zip."%'");
//////////////////////////////////// Pagination Setup ////////////////////////////////////

// Build the Output Section Here
$outputList = '';
while($row = mysql_fetch_array($sql)){

$id = $row["id"];
$firstname = $row["firstname"];
$city = $row["city"];
$zip = $row["zip"];
$skilled = $row["$skilled"];

}
?>


<form id="form3" name="form3" method="post" action="member_search.php">


<label for="skilled"></label>
<select name="skilled" id="skilled">
<option value="" selected="selected">Choose Skill</option>
<option value="Daycare">Daycare</option>
<option value="Tutoring">Tutoring</option>
<option value="Senior Sitting">Senior Sitting</option>
<option value="Lawn Maintenance">Lawn Maintenance</option>
<option value="Pool Maintenance">Pool Maintenance</option>
<option value="House Keeping">House Keeping</option>
<option value="General Labor">General Labor</option>
<option value="Carpentry">Carpentry</option>
<option value="Plumbing">Plumbing</option>
<option value="Flooring">Flooring</option>
<option value="Painting">Painting</option>
<option value="Handyman">Handyman</option>
<option value="Auto repair">Auto repair</option>
<option value="Heating Air">Heating Air</option>
<option value="Electrical">Electrical</option>
<option value="Consulting">Consulting</option>
<option value="Counseling">Counseling</option>
<option value="Accounting">Accounting</option>
<option value="Medical">Medical</option>
<option value="Veterinarian">Veterinarian</option>
<option value="Real Estate">Real Estate</option>
<option value="Legal">Legal</option>
</select>
<label for="zip">
<input name="zip" type="zip" id="zip" value="Enter Zip" />
<input type="submit" name="submit" value="Submit" />
</label>
</form></td>