Next Topic on Forum

[Anon]

I need to get the next topic on a forum im doing but i dont seem to get it to work.
This is what im doing..

first you press the NEXT TOPIC link
<A HREF="view.php3?id_foro=<? echo $id_foro ?>&next_topic=1&time=<? echo $ultima_fecha; ?>">NEXT topic</A>

and that reloads the page with the variables i need and next_topic=1, where "time" is the last time that topic had a post.

so it executes this code.

<?
if($next_topic==1)
{

	$result = mysql_query("SELECT post FROM foro_mensajes WHERE (fecha >'$time') AND id_foro='$id_foro' ORDER BY fecha DESC ");
	$myrow = mysql_fetch_array($result);
	$post = $myrow[post];
	header("Location: view.php3?id_foro=$id_foro&post=$post"); 
	exit;

}
?>

Thanks !