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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
