Re: where match question

Don wrote:

I have a db field that contains zip codes separated by comas. I am trying to get php to return all of the rows that contain a particular zip code. $query = "SELECT * FROM info WHERE MATCH (partialZIP) AGAINST ('$zip')";

try this $query = "SELECT * FROM info WHERE column LIKE '{$zip}'";

$result = mysql_query($query) or die ("could not connect to db"); $row = mysql_fetch_row($result); this works if there is only one row that contains that zip code. If there is more than one row that contains the zip, it returns 0 rows. ('It' being MYSQL that returns 0 rows. I checked this by running the query directly to the DB) Any ideas are very much appreciated. Thanks, Don