Jump to content

Archived

This topic is now archived and is closed to further replies.

boyx

Searching mysql database for 2 variables

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
my best guess would be that $keyword2 is undefined in this case, making it match anything in the second clause. what was being passed?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.