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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
