Programming a Forum

[MemphiS]

Could some users with experience provide smoe examples on how they access thier mysql data to display to the user.

 

I currently use the following method:

 

<?php
$forum = mysql_query("SELECT `id` , `topic_by` , `topic_header` , `date` FROM `forums` ORDER BY `date` LIMIT 0,30");
while ($getForum = mysql_fetch_row($forum)){
echo("<tr><td><a href='viewforum.php?view=$getForum[0]'>$getForum[2]</a> by $getForum[1] on $getForum[3]</td></tr>");
}
?>

 

Also i have replys showing the users posts, topics made and an image like this forum.  This lags the load time huge and i would like to improve it.

 

Just looking to improve load times.. =) Thanks

[redarrow]

<?php
$forum = mysql_query("SELECT `id` , `topic_by` , `topic_header` , `date` FROM `forums` ORDER BY `date` LIMIT 0,30");
while ($getForum = mysql_fetch_assoc($forum)){
echo("<tr><td><a href='viewforum.php?view=".$getForum["id
"]." '>".$getForum["topic_by"]."</a> by ".$getForum["topc_header"]." on ".$getForum["date"]."</td></tr>");
}
?>