Code: Select all
<?php
<?php
db_connect('lkcforum');
$sql = "SELECT name FROM forums WHERE forum_id='{$_GET['f']}'";
$result = mysql_query($sql,$con) or die(mysql_error());
$row = mysql_fetch_array($result);
$forum_name = $row['name'];
$sql = "SELECT subject,author,tid,forum_id FROM topics WHERE forum_id='{$_GET['f']}'";
$result = mysql_query($sql,$con) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$subject = $row['subject'];
$topic_id = $row['tid'];
$author = $row['author'];
$forum_id = $row['forum_id'];
$sql = "SELECT date FROM threads WHERE tid='$topic_id'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$date = $row['date'];
if (strlen($subject) > 42) {
$filler = "...";
$subject = substr($subject, 0, 42 - $filler) . $filler;
}
$topics .= "
<tr>
<td width=60%><a href=viewtopic.php?tid=".$topic_id."&fid=$forum_id>$subject</a></td>
<td width=20% align=center><a href=/myprofile/$author>$author</a></td>
<td width=20%>$date</td>
</tr>";
}
?>
?>Code: Select all
<?php
$sql = "SELECT date FROM threads WHERE tid='$topic_id'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$date = $row['date'];
?>