Posted by Mark D. Smith on 06/25/06 19:22

"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:d3ec6$449ec211$8259c69c$19891@news2.tudelft.nl...
> 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
>
>
Hi

once i removed the extra ) after $scr'

WHERE CONCAT(Job_Title, Job_Description, Job_Salary1) REGEXP '$src' AND
Job_location ="$loc"

the amount of data in the database is a little limited so the first few
$loc's don't hit but later combination of $loc and $src do.

Thanks again all working as i hoped.

Mark

• Next in forum: Best solution for ranking problem?
• Prev in forum: Re: search only certain columns in 1 table using php
• Thread view: Re: search only certain columns in 1 table using php

[Reply to this message]