Searching mysql database for 2 variables

[boyx]

I have a database that i can search for one variable,
now i would like it to match a first variable and a second in order to return a result,

II have this at the moment:

[code]$query = "SELECT *
       FROM  `pbx`
       WHERE  `swlevel` LIKE '$keyword%' AND `vm`='$keyword2%'";
[/code]

So keyword one checks swlevel and keyword 2 checks vm entry
problem is it seems to return mixed results,

I have one which is 23 and yes
and one that is 24 and none, but it returns both rows as valid results ...

Any hints or ideas? just getting used to this stuff.

[wisewood]

In my clients table, i have two clients whose company name contains 'afon'.

So, if i were to run: "SELECT * FROM clients WHERE company LIKE '%afon%'" it would return two results.

However, if i run: "SELECT * FROM clients WHERE company LIKE '%afon%' AND client_id = '2'" this will return only the one result.

This does work... as i am using it right now.

[akitchin]

my best guess would be that $keyword2 is undefined in this case, making it match anything in the second clause. what was being passed?