[SOLVED] getting the difference between a time and system time

[Vidya_tr]

  SELECT timediff('2009-04-30 14:40:00',sysdate());

 

this when done using mysql console returns the difference in time.

 

But how can I get the result of this query in a php variable??

 

Please help...

[ignace]

<?php
$query = "SELECT timediff('2009-04-30 14:40:00',sysdate()) as timedifference";
$queryResult = mysql_query($query);
list($timedifference) = mysql_fetch_array($queryResult, MYSQL_FETCH_NUM);
?>

[Vidya_tr]

I had an array on the above code you posted:some error on the parameters of mysql_fetch_array:

 

but got it like this....

<?php
$query = "SELECT timediff('2009-04-30 14:40:00',sysdate()) as timedifference";
$queryResult = mysql_query($query);
list($timedifference) = mysql_fetch_row($queryResult);
?>

 

thanks.....