RE: pick next birthday

[karnatic@xxxxxxx]

> ** Original Subject: RE: pick next birthday
> ** Original Sender: "Mr.Y.SHIVAKANT" <karnatic@xxxxxxx>
> ** Original Date: Wed, 3 Jan 2001 06:48:49 +0530

> ** Original Message follows... 

>
> -----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-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


>** --------- End Original Message ----------- **

> 

i am just checking my other new e-mail client

YOURS SINCERELY
Shivakanth



Download NeoPlanet at http://www.neoplanet.com


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60857@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