title: How to search multiple columns with one search using multiple inputs
body: <p>here is my php code:</p>
  
  <pre><code>if (($_REQUEST['Search']) || ($_REQUEST['CSV'])){
  $street = $_REQUEST['street'];
  $zip = $_REQUEST['zip'];
  $city = $_REQUEST['city'];
  $type = $_REQUEST['type'];
  if ($_REQUEST['street']){
      $q = " SELECT * FROM $usertable WHERE address LIKE '%$street%' ORDER BY address ";
  }
  if ($_REQUEST['zip']){
      $q = " SELECT * FROM $usertable WHERE zip LIKE '%$zip%' ORDER BY address ";
  }
  if ($_REQUEST['city']){
      $q = " SELECT * FROM $usertable WHERE city LIKE '%$city%' ORDER BY address ";
  }
  $qu = mysql_query($q);
  </code></pre>
  
  <p>Here is my html:</p>
  
  <pre><code>&lt;form action="" method="post"&gt;
  Zip:&lt;input name="zip" type="text" /&gt;
  Street:&lt;input name="street" type="text" /&gt;
  City:&lt;input name ="city" type="text" /&gt;
  Type:&lt;select id="type" name="type"&gt;
  &lt;option value="Invasion"&gt;Invasion&lt;/option&gt;
  &lt;option value="Burglary"&gt;Burglary&lt;/option&gt;
  &lt;option value="Theft"&gt;Theft&lt;/option&gt;
  &lt;/select&gt;
  &lt;input name="Search" type="submit" value="Search" /&gt;
  &lt;input name="CSV" type="submit" value="Get CSV" /&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>What I'm trying to do is have my site searchable using any combination of city zip or street.  I'm sure I'll have to concatenate or something, but as a backyard programmer I'm a bit stumped.  Thanks!</p>