Reply to Re: how might I accomplish this?

Your name:

Reply:


Posted by Tyrone Slothrop on 12/18/05 17:45

On Sat, 17 Dec 2005 22:21:17 -0800, gerg <noemail@noemail.com> wrote:

>I'm trying to create a site for my family and one of the features is
>going to be a "birthday" reminder of upcoming birthdays. I'm having
>each member register and in doing so enter their birthday in the
>following format:
>
>04-21-1983 or 11-23-1976
>
>What I want to do is write a script that will check the database from
>the current date, and then go out 30 days to check and see if any
>birthdays lie in that range. I guess I'm just not sure what my query
>should look like.
>
>So, taking today for instance, it's the 17th of Dec. I want to find out
>if there are any birthdays between the 17th of Dec and the 16th of Jan.
>Can anyone help me out with this?
>
>Thanks in advance.
>
>Greg

In MySQL a date would be saved in the format yyyy-mm-dd and, if you
stored the value in that format, the query would be like:
SELECT * FROM table WHERE (birthdate >= CURRENT_DATE() OR birthdate <=
DATE_ADD(CURRENT_DATE(),INTERVAL 30 DAY);

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация