My head dosent seem to get this logic...
This is the code:
Code: Select all
// database Table
// day , month , year are three different fields chars and year varchar(4)
// eg data 19 , 11, 1990
$birthdays = "10";
$daystime = time() + ($birthdays * 24 * 60 * 60 );
$lastday = date('Ynj', $daystime);
$lastdaymonth = date('n', $daystime);
$lastdayyear = date('Y', $daystime);
$tday= date(j);
$tmonth= date(n);
$tyear = date(Y);
$nowdate = date(Ynj);
//$todaymd= "$tyear$tmonth$tday";
$todaymd= "$tday$tmonth$tyear";
$qb = "select distinct `user`,`day`,`month`,`year` from `user` WHERE `month` = ('$tmonth') OR `month` > ('$tmonth') OR `month` = ('$lastdaymonth ') order by `year` ASC";
Any suggestions experts?
thanks
Arun