First - I would change "day,month,year" to a date field called 'birthdate'.
Then on the screen that the user chooses what to search for you let them
enter 1 or 2 or 3 values: the 'name', the 'city' or the 'age' (in years).
Then when you process that input, you determine what they entered - 1 or 2
or 3 things and build a WHERE clause based on 1 or 2 or 3 things.
For the Age filter you take it and subttract it from today's date (call it
'filterdate') and use the resulting date to say "birthdate >= filterdate"
Once you have your where clause built, you build your query and add the
where clause to it, like this:
$query = "SELECT * FROM $mydatabase WHERE $my_where_clause ORDER BY id DESC"
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP Home]
[PHP Users]
[Postgresql Discussion]
[Kernel Newbies]
[Plagiarism Notes]
[Postgresql]
[Yosemite News]
