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')"; $result = mysql_query($query) or die ("could not connect to db"); $row = mysql_fetch_row($result);

http://php.net/mysql_fetch_assoc has a better example. When there are many rows returned you need to loop to show them all: while ($row = mysql_fetch_assoc($result)) { print_r($row); } -- Postgresql & php tutorials http://www.designmagick.com/