I have an mysql database, with columns: id, name, day, month, year (this
last three birthdate), city,
I must to do a finder with filter.
This finder (or searcher) must can filter three thing: name, city and age.

I understand to do a finder with LIKE.
But I dont understand how or what I must to do to add the AND conditional,
and the WHERE.

I can do: query = "SELECT * FROM mydatabase WHERE name LIKE '%keyword%' AND
city LIKE '%keyword%' ORDER BY id DESC"

I dont know how to do the AGE part and the conditionals AND if the user can
search one or two or three filters.

Thanks a lot.


Emiliano Boragina
desarrollos + comunicación
+ 15 33 92 60 02
» emiliano.borag...@gmail.com
© 2011

Reply via email to