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

Groups > comp.lang.php > #2410 > unrolled thread

Get day and month part from date

Back to article view | Back to comp.lang.php

Contents

  Get day and month part from date Co <vonclausowitz@gmail.com> - 2011-06-30 01:21 -0700
    Re: Get day and month part from date Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-30 07:16 -0400
      Re: Get day and month part from date Bill B <me@privacy.net> - 2011-06-30 08:13 -0400
    Re: Get day and month part from date dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-30 21:02 +0000
    Re: Get day and month part from date Captain Paralytic <paul_lautman@yahoo.com> - 2011-07-01 03:29 -0700
      Re: Get day and month part from date Co <vonclausowitz@gmail.com> - 2011-07-03 08:20 -0700

#2410 — Get day and month part from date

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

[toc] | [next] | [standalone]

#2411

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.

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

[toc] | [prev] | [next] | [standalone]

#2412

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

[toc] | [prev] | [next] | [standalone]

#2415

In article <07dc80f0-d5cd-4390-a4f3-401de58d3b12@g9g2000yqb.googlegroups.com>, Co <vonclausowitz@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?

Yes, there is.

When will you figure out that PHP groups are not appropriate places to ask SQL 
questions?

[toc] | [prev] | [next] | [standalone]

#2419

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.

[toc] | [prev] | [next] | [standalone]

#2430

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.php

csiph-web