Jump to content


Photo

display birthdays this month


  • Please log in to reply
2 replies to this topic

#1 chery

chery
  • Members
  • PipPipPip
  • Advanced Member
  • 34 posts
  • Locationaustralia

Posted 22 May 2006 - 04:11 PM

I would like a php to display any 'username' who is having a birthday this calendar month with data retrieved from my db. The field is called birth_date and displays the dates like this: '1980-05-07'.
Thank you for your help.

chery
WWD GAMES - the BIGGEST little GAME site on the NET

#2 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 22 May 2006 - 04:34 PM

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] username FROM users WHERE MONTH(birth_date)=MONTH(NOW()) [!--sql2--][/div][!--sql3--]
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...

#3 chery

chery
  • Members
  • PipPipPip
  • Advanced Member
  • 34 posts
  • Locationaustralia

Posted 22 May 2006 - 04:49 PM

[!--quoteo(post=376075:date=May 22 2006, 12:34 PM:name=ryanlwh)--][div class=\'quotetop\']QUOTE(ryanlwh @ May 22 2006, 12:34 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] username FROM users WHERE MONTH(birth_date)=MONTH(NOW()) [!--sql2--][/div][!--sql3--]
[/quote]


But how do I display it on my webpage?
chery
WWD GAMES - the BIGGEST little GAME site on the NET




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users