Query a birthday based on the month

Dev Shed Forums Sponsor:

March 31st, 2010, 05:05 PM

blikecray

Registered User

Join Date: Mar 2010

Posts: 4

Time spent in forums: 2 h 40 m 7 sec
Reputation Power: 0

Query a birthday based on the month

I have a database with names and birthdays and I want a script that will show the upcoming birthdays for 1 month from the current date.

The birthdays are in DATE format within MySQL. (yyyy-mm-dd)

The code I was playing with below, obviously only shows the birthdays in the next month if the year is set to 2010, since it is looking for upcoming records within the current year. I only need it to pull based on the month. If that makes sense.

Example: If a record of 1987-04-02 is in the database right now it should be displayed but its not, but if I change it to 2010-04-02 then it shows, but I obviously don't want to do that with all my records every year lol.

PHP Code:


		
			
<? 



$result1 = mysql_query("SELECT name, birthday FROM address WHERE birthday BETWEEN CURDATE() AND CURDATE() + INTERVAL '1' MONTH"); 



echo "<th> Upcoming birthday!</th> </tr>"; 

while ( $row1=mysql_fetch_array($result1)) { 

echo "<tr>"; 

echo "<td>" . $row1['name'] . "</td>"; 

echo "</tr>"; } ?>

Any ideas what changes I can make to get this to work?

April 1st, 2010, 08:25 AM

ManiacDan

Likely to be eaten by a grue.

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,811

Folding Points: 127430 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 2 Months 3 Weeks 19 h 13 m 52 sec
Reputation Power: 6112

It's a little sloppy, but:

PHP Code:


		
			
 $result1 = mysql_query("SELECT name, birthday FROM address WHERE STR_TO_DATE(CONCAT(DATE_FORMAT(NOW(), '%Y'), '-', DATE_FORMAT(birthday, '%m'), '-', DATE_FORMAT(birthday, '%d'))) BETWEEN CURDATE() AND CURDATE() + INTERVAL '1' MONTH");

-Dan

__________________
HEY! YOU! Read the New User Guide and Forum Rules

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

Viewing: Dev Shed Forums > Programming Languages > PHP Development > Query a birthday based on the month

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump