Re: searching
| From: | CC Zona | Date: | Fri, 27 Oct 2000 01:29:00 +0000 |
| Subject: | Re: searching | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3978@lists.php.net to get a copy of this message | ||
In article <v04003a01b61e23c75c49@[204.181.16.152]>, bryan@concept-factory.com
(bryan) wrote:
> If I have a search function to search for anything in the database, how
> would I go about doing it?
>
> I know I have to
> $query = SELECT * FROM my_table;
> $result = mysql_results($query, $dbcnx);
>
> I know I have to loop through the $result, but what should I do to bang up
> against the db to search for a string from my input textbox?
If your MySQL version is at least 3.23.23, fulltext natural language searching
may be what you want. See
<http://www.mysql.com/documentation/mysql/commented/manual.php?section=MySQL_full
-text_search>
--
CC