FUDforum: comp.lang.php » get members who have birthday this week

Home » Imported messages » comp.lang.php » get members who have birthday this week

Show: Today's Messages :: Polls :: Message Navigator

Re: get members who have birthday this week [message #174730 is a reply to message #174728]

Wed, 29 June 2011 21:59

dougatmilmacdotcom
Messages: 24
Registered: May 2011

Karma:

Junior Member

In article <252495a8-76a0-41c0-bc2a-4c3f9b3e189b(at)j15g2000yqf(dot)googlegroups(dot)com>, Co <vonclausowitz(at)gmail(dot)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?

Report message to a moderator

[Message index]

		get members who have birthday this week By: Co on Wed, 29 June 2011 21:20
		Re: get members who have birthday this week By: Jerry Stuckle on Wed, 29 June 2011 21:29
		Re: get members who have birthday this week By: dougatmilmacdotcom on Wed, 29 June 2011 21:59

Previous Topic:	how to unset session variable when leaving page
Next Topic:	Windows binaries for the SAM (Simple Asynchronous Messaging for PHP) extension

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 19:19:55 GMT 2024

Total time taken to generate the page: 0.06212 seconds