Re: get members who have birthday this week

From	dougatmilmacdotcom@example.com (Doug Miller)
Newsgroups	comp.lang.php
Subject	Re: get members who have birthday this week
Date	2011-06-29 21:59 +0000
Organization	A noiseless patient Spider
Message-ID	<iug78k$hjp$1@dont-email.me> (permalink)
References	<252495a8-76a0-41c0-bc2a-4c3f9b3e189b@j15g2000yqf.googlegroups.com>

Show all headers | View raw

In article <252495a8-76a0-41c0-bc2a-4c3f9b3e189b@j15g2000yqf.googlegroups.com>, Co <vonclausowitz@gmail.com> wrote:
>Hi All,
>
>I want to display all members who have their birthday the coming week.
>I tried some code but it doesn't return any records. Probably because
>it looks for the date of birth
>instead of just the month and day:

So fix your query so it looks for what you want it to look for. And post in 
the proper newsgroup -- this is NOT a PHP issue.
>
>$today = date("d-m-Y");
>$birthday = $row['birthday'];
>
>$sql = mysql_query("SELECT * FROM myMembers WHERE birthday BETWEEN
>$today AND $today+7");
>
>Can anyone help me out here?

I'd love to help you out -- which way did you come in?

Back to comp.lang.php | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

get members who have birthday this week Co <vonclausowitz@gmail.com> - 2011-06-29 14:20 -0700
  Re: get members who have birthday this week Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-29 17:29 -0400
  Re: get members who have birthday this week dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-29 21:59 +0000

csiph-web