Query problem

[Anon]

I'm creating a search engine that will search on keyword as well as state. I'm having a problem making the below line of code work. Can someone tell me what I'm doing wrong?

$query="SELECT * FROM $tablename[$i] WHERE name = '%$keyword%' AND state = '$selectedstate'";

[Anon]

where name like '%$keyword%' or state....

like and or may help...

Kai

[Anon]

$query="SELECT FROM $tablename[$i] WHERE name = '%$keyword%' AND state = '$selectedstate'";
When using '%$variable%' you need like not =
so try
$query="SELECT FROM $tablename[$i] WHERE (name LIKE '%$keyword%') AND (state = '$selectedstate')";

[Anon]

I've gave the above a shot, but it seems to be pulling all records instead of just state=$selected state records.
Is there another way of wording that statement?