Date Time Php

  1. Home
  2. Php
  3. Date Time
  4. List people whose birthdays fall on the current Day and Month
// I wanted a simple way to find customers that had birthdays each day
// of the week so I could send them a card. Here it is, Hope it helps.
?>












$db = mysql_connect("localhost", "root");
$Date = date("m/d");
mysql_select_db("customers",$db);
$result = mysql_query("SELECT * FROM Cinfo WHERE Bday = '$Date'");
echo "\n";
echo "\n";
while ($myrow = mysql_fetch_row($result)) {
printf("\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4]);
}
echo "
First NameLast
Name		BirthdayYear
%s%s%s%s
\n";
?>


The date today is,