Hello, 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 ------------------------------------------
