Next birthday?

From: Date: Fri, 08 Mar 2002 10:29:45 +0000
Subject: Next birthday?
Groups: php.db 
Request: Send a blank email to php-db+get-17568@lists.php.net to get a copy of this message
I have a table called 'members' with a field (among many others) 'member_dob' - the birthday of a particular member. The data type of this field is date (YYYY-mm-dd). What I'd like to do now is to fetch one particular row from the database (I am using MySQL 3.23.37) - namely the row of the member who is the next one to have a birthday. Can this be done only with a advanced query or should I fetch all rows and use PHP to find out who is the next one to have a birthday? I'd prefer letting MySQL to do the job... Any ideas? TIA, Kristjan P.S. Pls. CC to kristk@ut.ee as well - I am only on the digest.

« previous php.db (#17568) next »