At 14:56 +0200 12/27/02, Patrascu Eugeniu wrote:
Hi,
I have a problem calculating birthdays in sql. Here goes my setup:
I have a database that contains the bithdays of a number of people,
and I want to know when there birthday is to congratulate them.
The thing is that I want to now that a day
PROTECTED]
- Original Message -
From: "Patrascu Eugeniu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 27, 2002 2:56 PM
Subject: birthday calculation problem
> Hi,
>
> I have a problem calculating birthdays in sql. Here goes my setup
PROTECTED]
- Original Message -
From: "Patrascu Eugeniu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 27, 2002 2:56 PM
Subject: birthday calculation problem
> Hi,
>
> I have a problem calculating birthdays in sql. Here goes my setup
Not tested. You should have table "dates" with columns "email" and
"birthday". "birthday" is in format "27 December"
#!/bin/sh
dbname="birthday"
dbhost="localhost"
dbuser="alpha"
dbpass="beta"
persons=`mysql -h$dbhost -u$dbuser -p$dbpass $dbname --execute="select
email from dates where date_for
Hi,
I have a problem calculating birthdays in sql. Here goes my setup:
I have a database that contains the bithdays of a number of people, and
I want to know when there birthday is to congratulate them.
The thing is that I want to now that a day before their birthday.
Therefore I need a way to
