Re: searching multiple fields
| From: | Lawrence Kennon | Date: | Thu, 14 Jul 2005 10:07:50 +0000 |
| Subject: | Re: searching multiple fields | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-218669@lists.php.net to get a copy of this message | ||
>...I want it to do the folowing.
>
>$query = "SELECT * FROM sheet1 WHERE 'name' or 'area or 'organisation
>LIKE
>'$search_field%'";
>
"SELECT * FROM sheet1 WHERE 'name' LIKE '$search_field%'
OR 'organization' LIKE '$search_field%'"
lk