You need a button to make it go.

You can also just hit enter...

10 laatste forumposts

Dit is het begin van: url3.php

php-Script gemaakt door Ron van Setten
Licht aangepast door Leon Klomp

-->

Verbinding mislukt: '.mysql_error());
}
else
{
if($pw == '')
{
$pw = 'geen password opgegeven';
}

$select_db = @mysql_select_db($db);

if (!$select_db)
{
die('Selecteren database '.$db.' is niet gelukt: '.mysql_error());
}
else
{
$sql = 'SELECT a.post_time
,a.post_id
,a.topic_id
,a.poster_id
,b.username
,c.topic_title
FROM '.$table.' AS a
,'.$table2.' AS b
,'.$table3.' AS c
WHERE a.poster_id=b.user_id AND a.topic_id=c.topic_id
ORDER BY post_time DESC
LIMIT 10'
;

$query = @mysql_query($sql);

if (!$query)
{
die('query not ok: '.mysql_error());
}
else
{
echo '';
/* echo ' ';
echo ' Laatste 10';
echo ' ';*/

while ($data = @mysql_fetch_assoc($query))

if (!$data)
{
die('Overhalen data mislukt: '.mysql_error());
}
else
{
echo ' ';
echo ' ';

echo $data['username'];
echo ' ';
echo ' ';
$url = ''.$data['topic_title'].'';
echo $url ;
echo ' ';
echo ' ';
echo $data ['post_time'];
echo ' ';
}

mysql_free_result($query);

mysql_close($connect);

echo '';
}
}
}
?>

What do I need to do for the last column, in this form it reads the unix timestamp from the database ?

It is not completely obvious in which timezone the current and converted time are given. Perhaps ask the user about his preferred timezone.