Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #2408

Re: get members who have birthday this week

Show all headers | View raw

On 6/29/2011 5:20 PM, Co 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:
>
> $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?
>
> Marco

This is a MySQL question, not a PHP one (hint: PHP knows NOTHING about SQL).

I would suggest you ask in comp.databases.mysql.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next 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