show birthday

[Uncoder]

Hi,

How to show list of user today bithday ?!

Mysql :

ID | Username | name | date (00-00-0000)

Thanks

[Rampage-Obidos]

It's not the best way, but something like this:

$Today = date("d-m");

$result = mysql_query("SELECT name,date FROM (Table) WHERE date LIKE '$Today%'");
$count = @mysql_numrows($result);

for($i=0;$i<$count;$i++){
echo mysql_result($result,"$i","name");
}

[Uncoder]

Thanks Rampage-Obidos, Your Code Is Basic and fantasic. But not Best Way .

Any Other Idea !?!

[dagon]

WHERE MONTH(CURDATE()) = MONTH(date) AND DAY(CURDATE()) = DAY(date)

or
WHERE date LIKE '%-MONTH(CURDATE())-DAY(CURDATE())'

there are a few options of you goggle it