Hi People, Need a little assistance with the following MySQL query:-
$query = "SELECT employ_id,company FROM employers WHERE employ_id REGEXP '($employ_id)' OR company REGEXP '($name)' OR industry REGEXP '($industry)'"; The above query gets the variables $employ_id, $name and $industry from a search box on a previous page. I can confirm that the variables are being parsed to the query. The problem is that the above query appears to match everything in the table, from any of the fields and thus just dumps out the entire contents of the table, instead of only selecting the ones that match the search criteria. Basically I have a variable passed to the query and it must return the values from the table that have the variable in its entirety somewhere in the fields value. In addition to this, once I have it selecting the correct values and returning them to me. What can I do to show a 'No Results' situation? Any help woul dbe gratly appreciated. Cheers, Shannon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
