Posted by Richard Davey on 07/14/05 12:14

Hello Ross,

Thursday, July 14, 2005, 9:37:10 AM, you wrote:

R> $query = "SELECT * FROM sheet1 WHERE 'name' or 'area or 'organisation LIKE
R> '$search_field%'";

SELECT * FROM blah WHERE name LIKE '$search%' OR area LIKE '$search%'
OR blahblah LIKE '$search%'

etc

If you want to add extra conditions you can do so like this:

SELECT * FROM blah WHERE (name LIKE '$search%' AND id > 10) OR area LIKE '$search%'

Best regards,

Richard Davey
--
http://www.launchcode.co.uk - PHP Development Services
"I do not fear computers. I fear the lack of them." - Isaac Asimov

• Next in forum: Big file encryption
• Prev in forum: searching multiple fields
• Thread view: Re: [PHP] searching multiple fields

[Reply to this message]