Simple searching

[Sharif]

Ok, here is the task at hand: I have to search through a table and get results depending on two fields: state and city.

State is chosen from a drop down menu, but city is stated by a text field. Now I need to get records for the selected state and city, how do I begin:

"SELECT * FROM table WHERE state = '" . $_POST['state'] . "' AND city =" ... I don't know what city should equal to.

[Sharif]

Maybe this is a solution:

"SELECT * FROM table WHERE state = '" . $POST['state'] . "' AND city LIKE '%" . $POST['city'] . "%'"

[Sharif]

Ok that works perfectly (solved my own thread). Any tips on making it more efficient?