$pages - 1) $page = $pages - 1; $offset = $page * $threadsperpage; $fq = mysqli_query($conn, "SELECT * FROM forum WHERE category='$topic' AND reply_to='0' ORDER BY is_pinned DESC, time_posted DESC") or die(mysqli_error($conn)); ?>
     
 
Search this forum:
0) { $lastreply = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM forum WHERE reply_to='{$post['id']}' ORDER BY id DESC LIMIT 1")); $lrtimeago = forumtime($lastreply['time_posted']); $lrauthor = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM users WHERE id='{$lastreply['author']}'")); $lrstring = "$lrtimeago
by {$lrauthor['username']}"; } else { $lrstring = ""; } echo ""; } ?>
 Thread  Started By  Replies  Views  Last Post 
{$post['title']} {$author['username']} $replies -
$lrstring