php mysql昨日数据,php mysql今天，昨天和日期从数据库

I am trying to save date when the user log out so that he can find the date of the last login, I am using this code:

mysql_query("UPDATE `table` SET `lastLog` = now() WHERE user_id = '".$_SESSION['userID']."'");

which will give the history and the time of the last login correctly but I want the code to show the word today if the last login was today and yesterday if the last login was yesterday. and after yesterday I want to show only the regular date for example if I logged out three days ago then the value should be like this: 8/7/2014. is there an easy way to do it.

解决方案$result = mysql_query("select lastLog from `table` WHERE user_id = '".$_SESSION['userID']."'");

while($row = mysql_fetch_array($result))

{

$last_login = $row['lastLog '];

}

if($last_login == date('d.m.Y'))

echo "its today";

if($last_login == date('d.m.Y',strtotime("-1 days")))

echo "it was yesterday";

else

echo 'it was '.$last_login;