You are here: Re: Birthdays « PHP Programming Language « IT news, forums, messages
Re: Birthdays

Posted by Lars Eighner on 06/23/07 19:34

In our last episode, <f39fi.2768$ZA.1266@newsb.telia.net>, the lovely and
talented Bo Wisén broadcast on comp.lang.php:

> In a MYSQL database I have stored when the members were born in the form
> "YYYYMMDD". Now I want a method to select every member who has birthday from
> today and up to 30 days into the future. I would prefer if this could be
> done in a MYSQL query.

Well then, this would seem to be a MySQL question. See 'Date and Time
Functions' in the MySQL Manual.

> Can anyone tell me how to do this? I have figured out some solutions that
> will work, but unfortunately not in December because the year will turn.


--
Lars Eighner <http://larseighner.com/> <http://myspace.com/larseighner>
Countdown: 576 days to go.
Owing to googlegroups not screening users to eliminate spammers and other
USENET abusers, I do not see most posts from googlegroups.

 

Navigation:

[Reply to this 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

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