login days in a row

[jwk811]

this is driving me crazy. what im trying to see if count how many days a user logs in in a row.

 

the first part works where it checks to see if they logged in yesterday if yes it adds to the login days. if no it checks to see if its been longer than yesterday in that case it would go back to 0. if they are logging in again that day it wont do anything.

 

$yesterday  = date('Y-m-d 00:00:00', strtotime('-1 day'));
$yesterday2 = date('Y-m-d 23:59:59', strtotime('-1 day'));

$sql = "SELECT user_last_login FROM tbl_user
        WHERE user_id = '{$row['user_id']}' AND user_last_login >= '$yesterday' AND user_last_login <= '$yesterday2'";
$result = dbQuery($sql);

if(dbNumRows($result) == 1){

            $sql = "UPDATE tbl_user 
                    SET user_daily = user_daily + 1
                    WHERE user_id = '{$row['user_id']}'";
            dbQuery($sql);
}
else{

$sql = "SELECT * FROM tbl_user
        WHERE user_id = '{$row['user_id']}' AND user_last_login > '$yesterday'";
$result = dbQuery($sql);


	if(dbNumRows($result) == 1){

           		 $sql = "UPDATE tbl_user 
            	        SET user_daily = 1
             	   	    WHERE user_id = '{$row['user_id']}'";
           		 dbQuery($sql);

	}
}

 

$sql = "SELECT * FROM tbl_user

        WHERE user_id = '{$row['user_id']}' AND user_last_login > '$yesterday'";

$result = dbQuery($sql);

 

 

if(dbNumRows($result) == 1){

 

^^ that part isnt working. for some reason its not getting that its been longer than yesterday and ive changed it to over a week since last login and it wont do it. its not getting any rows its not a problem with the update. please help

[Masna]

Might I suggest using UNIX timestamps instead of MySQL DATETIME format.

 

$yesterday = time() + (60*60*24);

[jwk811]

how would that be yesterday?

[jlhaslip]

He travels very quickly. 

 

try subtracting.