All pastes #550740 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-06-08 14:56 UTC
rendered paste body
echo "<div id='phpbb1'>
<table>
<tr>
<td colspan='2'>Latest Topics</td>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td><a href='phpBB/viewtopic.php?t=" . $row['topic_id'] ."' >" . $row['topic_title'] . "</a></td>";
  echo "<td>" . date('M d g:i', $row['topic_time']) . "</td>";
  echo "</tr>";
  }
  echo "</table>\n</div>";
$result = mysql_query("SELECT phpbb_posts.topic_id, phpbb_topics.topic_title FROM phpbb_topics, phpbb_posts WHERE phpbb_posts.topic_id=phpbb_topics.topic_id ORDER BY post_time DESC LIMIT 3");

echo "<div id='phpbb2'>
<table>
<tr>
<td colspan='2'>Latest Posts</td>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td><a href='phpBB/veiwtopic.php?t=" . $row['topic_id'] ."'>" . $row['topic_title'] . "</a></td>";
  echo "<td>" . date('M d g:i', $row['post_time']) . "</td>";
  }
  echo "</tr>
  </table>
  </div>";