Posted by Rik on 06/25/06 17:05

Mark D. Smith wrote:
> I now have a new test the apply
>
> CONCAT(Job_Title, Job_Description, Job_Salary1) REGEXP '$src') works
> but i need to add a test for where
>
> Job_Location ="$loc" ($loc is a number 1 to 19) currently
>
> tried
> WHERE CONCAT(Job_Title, Job_Description, Job_Salary1) REGEXP '$src')
> AND Job_location ="$loc"
> but no luck

Echo your query, what does it actually like with the variables?
It should work, what if you try:
WHERE Job_location = "$loc"

Does that return any hits?

Grtz,
--
Rik Wasmus

[Back to original message]