RE: where match question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux