[PHP-DB] REGEXP and Variables.

2003-10-09 Thread Shannon Doyle
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

Re: [PHP-DB] REGEXP and Variables.

2003-10-09 Thread Ignatius Reilly
-DB] REGEXP and Variables. 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