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 #174750 is a reply to message #174740]

Sun, 03 July 2011 15:20

Co
Messages: 75
Registered: May 2011

Karma:

Member

On 1 jul, 12:29, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On Jun 30, 9:21 am, Co <vonclausow...@gmail.com> 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
>
> It doesn't matter how many times you ask this question, it will still
> remain a MySQL question and not a php one.
>
> One general hint is that if you want to invent your own syntax, you
> will need to build your own programming language. If you wish to use
> the MySQL programming language then you must stick to the syntax as
> published in its manual.

I get the point guys.
I just thought there might be a PHP solution instead of editing the
query.

Marco

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: Wed Nov 27 07:04:43 GMT 2024

Total time taken to generate the page: 0.04490 seconds