time-difference

[Anon]

hello!

we print out recordsets from a mysql-db in a html-tabelle. in every recordset we have a field with the unix-timestamp. how can we print out the timedifference (delta t) in a html-table (just seconds needed!) between a recordset an the recordset before?

the code:

echo"<table>\n
<tr>\n
<td>page</td>\n
<td>time</td>\n
<td>ip</td>\n
<td>timestamp</td>\n
<td>delta t</td>\n
</tr>\n";

for($i=0;$i<$num;$i++)
{
$page=mysql_result($select, $i, "page");
$time=mysql_result($select, $i, "time");
$ip=mysql_result($select, $i, "ip");
$timestamp=mysql_result($select, $i, "timestamp"); /here we have the unix-timestamp /

$delta_t="???????";

echo "<tr>\n
<td>$page</td>\n
<td>$time</td>\n
<td>$ip</td>\n
<td>$timestamp</td>
<td>$delta_t</td>\n</tr>\n"; / here we want to print out the timedifference(just seconds needed!) according to the recordset that was printed out before/
}

echo"</table>\n";

many thanks in advance, rainer.

[bretticus]

First of all, may I ask why you are using mysql_result instead of returning the entire recordset within one result?

Secondly...to better answer your question. Are the timestamps truely a UNIX timestamp (total seconds from 1/1/1970) or are they a MySQL timestamp (YYYYMMDDHHMMSS)?

A true UNIX timestamp involves simply subtracting period 1 from period 2.

You can do the same with a MySQL timestamp. You just query the field via select '...UNIX_TIMESTAMP(field) AS unixtime...' in MySQL. The you do your subtraction.