Workout out Birthdays

[onlyican]

First, on the note of Birthdays
Happy Birthday google, 8 years, they grow up soo fast

Anyway

I store users DOB's in the MySQL table, in Mysql Format (2006-09-27)

WHats the best way to work out whos birthday it is today

I was thinking either
$today = date("m-d");
$query1 = "SELECT * FROM members WHERE dob LIKE '%".$today."' ";
OR
$today = date("m-d");
$query1 = "SELECT * FROM members WHERE dob BETWEEN '1000-".$today."' AND '30-".$today."'";

What do u think
Or any better ideas

Also,

Is there a database I can get Celebs birthdays from
So I can
This persons birthday is also today...

[obsidian]

as for the individual user b-days, just use this:
[code]
<?php
$day = date('d');
$mon = date('m');
$sql = mysql_query("SELECT username FROM users WHERE MONTH(DOB) = '$mon' AND DAYOFMONTH(DOB) = '$day'");
?>
[/code]

[onlyican]

Wicked, I didn't know about the MONTH and DAY features

[acdx]

Even better is:

[code]<?php
$query1 = mysql_query("select * from members where month(dob) = month(curdate()) and day(dob) = day(curdate())");
?>[/code]

[onlyican]

Excellent

Now I need to build a database to Famous Disabled people, and there birthdays
Wish me luck