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); } Don wrote: > I appreciate your quick response, but I think the problem I'm having > is in the query. Is WHERE MATCH () the proper format to use for > getting multiple rows from the DB? Or is there something else I'm > missing? Please don't top post, it's hard to follow what's going on and who's replied. Sorry, I misread your email. "Match against" is meant to be for fulltext searches, that includes some limitations. http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html Specifically the last 3-4 paragraphs. ~~~~~~~ Alright, I learned 2 things.... What top post is....lol (sorry) And don't' skim through the manual.... programming isn't like legos where you can look at the picture and put it together.... query = "SELECT * FROM info WHERE MATCH (partialZIP) AGAINST ('$zip' in Boolean mode)"; Made all the difference... I missed the part about stop words and had only 2 entries in my DB. So thanks for pointing that out. Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php