|
Posted by "Ross" on 07/14/05 11:37
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.
Navigation:
[Reply to this message]
|