FUDforum: comp.lang.php » Get day and month part from date

Home » Imported messages » comp.lang.php » Get day and month part from date

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

Re: Get day and month part from date [message #174733 is a reply to message #174732]

Thu, 30 June 2011 12:13

me
Messages: 192
Registered: September 2010

Karma:

Senior Member

On 6/30/2011 7:16 AM, Jerry Stuckle wrote:
> On 6/30/2011 4:21 AM, Co wrote:
>> Hi All,
>>
>> I would like to retrieve people's birthday from the database.
>> But only those who celebrate the coming week.
>>
>> SELECT * FROM members WHERE birthday BETWEEN $today AND $today+7
>>
>>
>> The birthday field holds also the year but I just need day and month.
>> Is there a way to do this?
>>
>> Marco
>
> Like I told you yesterday - this is not a PHP question. Try an
> appropriate newsgroup, such as comp.databases.mysql.
>
> Ask in the right place and you'll get a good answer.

The best help for forming the query is indeed in the mysql newsgroup.
Insofar as incorporating the query into your PHP code,
http://www.php.net/manual/en/ref.mysql.php may be helpful. The related
pages have many query examples that may be useful to you.

Bill B

Report message to a moderator

[Message index]

		Get day and month part from date By: Co on Thu, 30 June 2011 08:21
		Re: Get day and month part from date By: Jerry Stuckle on Thu, 30 June 2011 11:16
		Re: Get day and month part from date By: me on Thu, 30 June 2011 12:13
		Re: Get day and month part from date By: dougatmilmacdotcom on Thu, 30 June 2011 21:02
		Re: Get day and month part from date By: Captain Paralytic on Fri, 01 July 2011 10:29
		Re: Get day and month part from date By: Co on Sun, 03 July 2011 15:20

Previous Topic:	barcode reader integration in web application
Next Topic:	show events in calendar

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 01:14:30 GMT 2024

Total time taken to generate the page: 0.04028 seconds