[SOLVED] How many seconds passed

[EchoFool]

I am trying to make a field in my query to hold how many seconds have passed from a date in my table but it keeps returning total number of days passed so i get a return of 0. What function should i actually be using ?

 

This is what i tried:

<?php
$GetDate = mysql_query("SELECT DATEDIFF(NOW(), Date) AS  SecondsPassed FROM users
				WHERE  UserID='{$_SESSION['Current_User']}'")
				or die(mysql_error());
?>

 

Hope you can help me.

[rhodesa]

try:

<?php
$GetDate = mysql_query("SELECT TIME_TO_SEC(TIMEDIFF(NOW(), `Date`)) AS  SecondsPassed FROM users
               WHERE  UserID='{$_SESSION['Current_User']}'")
               or die(mysql_error());
?>

[EchoFool]

Thanks worked a treat.