Re: [PHP] searching multiple fields

[Lawrence Kennon]

>...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