I need to split the keyword on search input and generate an sql query, for ex: the input value is: europe+america,asia so I want to generate an sql like this: SELECT * FROM mytable WHERE message LIKE %europe% AND message LIKE %america% OR message LIKE %asia%
The + (plus) means AND and , (comma) means OR. Also I need to control input variables to prevent error on sql query forexample an input value like: ,,,europe+america,+asia+ should not generate an error. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
