Code: Select all
<?
ini_set('date.timezone', 'America/Los_Angeles');
?>
<?
$enteredby = $row['acctid'];
$newweightquery = "SELECT entrydt FROM table WHERE enteredby = $enteredby ORDER BY entrydt DESC LIMIT 1,1";
$newresult = mysql_query($newweightquery);
while($row = mysql_fetch_array($newresult)){
$dtdisplay = $row['entrydt'];
}
$todaysdt = date('Y-m-d',time());
$yesterdaysdt = date('Y-m-d',(strtotime('-1 day', strtotime($todaysdt))));
echo "today's date: $todaysdt <br>";
echo "yesterday's date: $yesterdaysdt <br>";
echo "Entry Dt of record in database: $dtdisplay <br>";
if($todaysdt == $dtdisplay){
echo "today";
}
elseif($yesterdaysdt == $dtdisplay){
echo "yesterday";
}
elseif($todaysdt <> $dtdisplay && $yesterdaysdt <> $dtdisplay){
echo date('m-d-Y',strtotime($dtdisplay));
}
?>