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
