Multiple search variables

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
pinehead18
Forum Contributor
Posts: 329
Joined: Thu Jul 31, 2003 9:20 pm

Multiple search variables

Post by pinehead18 »

Ok, what i'm attempting to do is write a php sql script that will allow me to search based off specific vars.

Such as between Age1 and age1 and in the city of some city..

So basically 3 search peremiters on one search..

Any ideas suggestions or links to code?

Thank you
Anthony
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

Add

Code: Select all

WHERE (age > $agemin) AND (age < $agemax) AND (city = $city)
Into your SQL statement
Post Reply