Re: pick next birthday

["Mr.Y.SHIVAKANT" <karnatic@xxxxxxx>]

-----Original Message-----
From: Webmaster <webmaster@xxxxxxx>
To: mysql@xxxxxxxxxxxxxxx <mysql@xxxxxxxxxxxxxxx>
Date: Tuesday, January 02, 2001 8:41 AM
Subject: pick next birthday


>This MAY be a duplicate.  I posted through Deja.com but I am not sure if
>mail gets here from that method.
>
>I need to have a table that has (among others) a field that contains a
>birthdate. I want to select the record from the table that has todays date
>as the birthday or (if none matches today) the next upcoming birthday. What
>I want to display is this.
>
>If someone has a birthday today:
>A message about Happy Birthday and the persons age.
>
>If no birthday today:
>A message saying who's birthday is next and how old they will be.
>
>
>There will be NO duplicate birthdates.
>
>
>Any help on the SQL please...
>
>(Feel free to define whatever field(s) you need to make the code as simple
>as you want.)
>
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php"; before
>posting. To request this thread, e-mail mysql-thread60350@xxxxxxxxxxxxxxx
>
>To unsubscribe, send a message to:
>    <mysql-unsubscribe-karnatic=eth.net@xxxxxxxxxxxxxxx>
>
>If you have a broken mail client that cannot send a message to
>the above address (Microsoft Outlook), you can use:
>    http://lists.mysql.com/php/unsubscribe.php
>
select name where b-day=today() ;
select name where min(b-day=today());this is usual problem.


I will send you more authentic algo's in the days to come please dont drop
me from this list.

YOURS SINCERELY
Shivakanth

The bottomline is The punchline....



-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60459@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php