Search in php and mysql

[pinehead18]

I'm attempted to write a sort of "advanced search" script to search through my data bases. My goal is for it to return the results that are similar but doens't have to be exactly the same as the search criteria specified by the user.

Here is my sql statement

$sql = " SELECT * FROM users WHERE (age > $agemin) AND (age < $agemax) AND (city '%like%' $city)";

Does this look remotly right?

Thank you
Anthony

[AstroTeg]

$sql = " SELECT * FROM users WHERE (age > $agemin) AND (age < $agemax) AND (city '%like%' $city)";

For agemin and agemax, what you have will work. You could also do "WHERE age BETWEEN $agemin AND $agemax"

For the city, thats not going to work. "LIKE" is a SQL statement. You have it wrapped in quotes with the seach character '%' wrapped around it. What you'll want is something like this:

AND city LIKE '%$city%'

Put it all together:

$sql = " SELECT * FROM users WHERE (age > $agemin) AND (age < $agemax) AND city LIKE '%$city%'"; 

[pinehead18]

Awsome, thank you