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



PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to