searching multiple fields
| From: | Ross | Date: | Thu, 14 Jul 2005 08:37:10 +0000 |
| Subject: | searching multiple fields | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-218659@lists.php.net to get a copy of this message | ||
Is there a way to use like to search various fields at one time.
For example I want the search field to search by name or area or
organisation. If the (minimum)three letter string matches any of these I
want the record to show. $search_field is my textbox
$query = "SELECT * FROM sheet1 WHERE 'name' LIKE '$search_field%'";
but really I want it to do the folowing.
$query = "SELECT * FROM sheet1 WHERE 'name' or 'area or 'organisation LIKE
'$search_field%'";
Cheers,
R.