Viewing records according to a date.

[Anon]

Hi

I have created a database with a table that contains employee information. In one of the fields which is name fld_Employee_DOB I have inserted the employees date of birth which sits in the database in the format mm/dd/yyyy

The problem is, I want the html page to display the persons name if it is their birthday, but it only shows the birthday if the year is part of the date. What SQL statement do I use to select the day and month to display the correct information.

Any help would be appreciated.

Thanks

[dmills]

maybe your select could use

select .... like 'mm/dd%'

and then use php string functions to strip off year

[[deleted]]

Does your database contain a DATE field for the birthday date (good) or did you use a string field (bad, very bad)

If it's a date field you can simply compare the month() and dayofmonth() of the date field with the current date.

[craigh]

well, maybe not "bad, very bad" but at least inconvienent...

you could recover the date from the DB then explode it into a list:

list ($month, $date, $year)=explode("/", $row['date']);

$current_date=date("d");
$current_month=date("m");

if (($month == $current_month) AND ($date==$current_date)) then {

// display name or whatever //

}

I haven't checked the code, use at your own risk.

[[deleted]]

Hmm.. if that's your definition of 'inconvenient' I shudder to think what you find 'bad, very bad' :-)

This method will fetch all records from the database and only print those that match the string-date.

What you want is an SQL query that only returns those records that you need.
In the case of a string-type-date, you should use the LIKE operator to match dates that are LIKE the target date.
But ideally you'd want to just tell the database which month and day-of-month you are looking for.