title: Query works in phpMyAdmin but not through mysql_query
body: <p>I'm stumped.  Why would a query work in phpMyAdmin but not in a MAMP environment? I've echoed out the query, which returned 0 results in MAMP, copied it and pasted it into phpMyAdmin and the same query returns the expected result.</p>
  
  <pre><code>select
     c.id
  from
      (select id, business_id 
       from coup 
       where match(name) against ('$search')
      ) as c
      left join
         (select business_id 
          from bus 
          where match(name, category, subcat) against ('$search')
         ) as b on
          c.business_id = b.business_id 
      inner join bloc z on
          c.business_id = z.business_id
  where
      z.zip = '$zip'
  </code></pre>
  
  <p>Below are the lines as they appear in the code</p>
  
  <pre><code>$q = "select c.id from (select id, business_id from ".TBL_COUPONS." where match(name) against ('".$search."')) as c left join (select business_id from ".TBL_BUSINESS." where match(name, category, subcat) against ('".$search."')) as b on c.business_id = b.business_id inner join ".TBL_BLOCATION." as l on c.business_id = l.business_id where l.zip = '".$zip."'";
  $rs = mysql_query($q) or die(mysql_error());
  $rec = array();
  while(($row = mysql_fetch_array($rs)) !== FALSE ){
      $rec[] = $row[0];   
  }
  </code></pre>
  
  <p>echo $q shows:</p>
  
  <pre><code>select c.id from (select id, business_id from coupons where match(name) against ('walk')) as c left join (select business_id from business where match(name, category, subcat) against ('walk')) as b on c.business_id = b.business_id inner join buslocations as l on c.business_id = l.business_id where l.zip = '91326' 
  </code></pre>