cant make multiple condition search??

[lovewala]

Hi! :confused:

I'm a newbie programmer.

i trying to make search option with multiple options like keyword, city, state, country etc.

but i dont know how to use sql with multiple conditions.

i can search with 2 or 3 conditions only.

please help.

thanks in advance

senthil

[abduraooft]

i trying to make search option with multiple options like keyword, city, state, country etc.

but i dont know how to use sql with multiple conditions.

i can search with 2 or 3 conditions only.
Please post the code that you've so far.

[WhaLberg]

http://dev.mysql.com/doc/refman/4.1/en/where-optimizations.html