need help
Posted: Tue Aug 11, 2009 11:47 am
Code: Select all
$result1 = mysql_query("SELECT id,name,email,dob,DAYOFYEAR(dob + INTERVAL YEAR(NOW()) -YEAR(dob) YEAR) -
DAYOFYEAR(NOW()) as days FROM tcemcac_tcemca.personal order by days");
while($row = mysql_fetch_array($result1))
{
if($row['days']== 0 && $row['dob'] != 0000-00-00 )
{
$na = $row['name'];
$em= $row['email'];
$dat= $row['dob'];
list($month, $day, $year) = split('[/.-]', $dat);
$dates= $day;
}
}thanks in advance