Last Seen

[N-Bomb(Nerd)]

Hello, I'm creating a last seen script for my website and ran into a bit of trouble. I'm able to store when the user was last seen, and even pull that information from the database, however I have no idea how to use the DATEDIFF function with mySQL.

 

Here's my test code so far.. Also let me know if you see a way I could improve this.

 

function test() {
if (mySQLConnect('host', 'db', 'username', 'password') == true) {
	$Query = mysql_fetch_array(mysql_query("SELECT * FROM TimeTable WHERE username = 'workgoddamnit'"));

	echo $Query['username'] . ' was last seen ' . ????

}
}

 

I'm able to format the date myself, heh just I don't know how to use DATEDIFF properly.. any help is much appreciated.

[N-Bomb(Nerd)]

Whoops, forgot to mention that my database consists of two fields.. "username" and "last".

 

"last" being the last seen time.

[Ken2k7]

$Query['last']?

[N-Bomb(Nerd)]

$Query['last']?

 

Yes, that contains the time the user was last seen, however I'm trying to get the difference between the time he was last seen and the current time.

[jackpf]

$d = time() - $last;
echo date('H:i', $d);

 

Somethign along those lines.

[fenway]

DATEDIFF( yourField, NOW() )

[N-Bomb(Nerd)]

DATEDIFF( yourField, NOW() )

 

I'm sorry, I've tried to mess with that for a bit now and I can't quite figure out how to get that to work in my query. Could you perhaps give me an example using that?

[kickstart]

Hi

 

Put it in something like this:-

 

function test() {

  if (mySQLConnect('host', 'db', 'username', 'password') == true) {

      $Query = mysql_fetch_array(mysql_query("SELECT username, last, DATEDIFF(last,NOW()) TimeSinceLastTouchedInDays FROM TimeTable WHERE username = 'workgoddamnit'"));

 

      echo $Query['username'] . ' was last seen ' . $Query['TimeSinceLastTouchedInDays '];

 

  }

}

 

This will return the number of days since the were last seen as a field called TimeSinceLastTouchedInDays .

 

All the best

 

Keith

[N-Bomb(Nerd)]

Keith,

 

I've tried the code that you've posted, and I can't seem to get it to work. Usually if I mess around enough with the code I can get it to work, this doesn't seem to be the case this time. Any suggestions on what I should do?

 

I know this isn't a good reply because I didn't reply any output simply for the fact that there was none.

[kickstart]

Hi

 

Do you have something like phpmyadmin to just execute the SQL in directly? If so give that a try.

 

All the best

 

Keith