get_from_database($_GET['id'], $dbc); } ?> <?php echo $current->name; ?> - cflip.net forum

name; ?>

description; ?>

thread_count . ' threads, ' . $current->post_count . ' posts'; ?>

Threads

get_threads(); for each thread { $thread->get_latest_post(); } $sql = " SELECT thread_id, thread_subject, thread_date_created, thread_date_lastpost, thread_category, thread_author, user_id, user_name FROM threads LEFT JOIN users ON thread_author = user_id WHERE thread_category = " . $_GET['id']; $result = mysqli_query($dbc, $sql); if (!$result) { die('Error trying to display posts: ' . mysqli_error($dbc)); } if (mysqli_num_rows($result) == 0) { echo 'No categories found!'; } else { while ($row = mysqli_fetch_assoc($result)) { echo ''; echo ''; echo ''; echo ''; } } ?>

Thread Name	Latest Post
' . $row['thread_subject'] . ' '; echo 'by ' . $row['user_name'] . ' on ' . date('M d, Y', strtotime($row['thread_date_created'])) . '	' . date('M d, Y', strtotime($row['thread_date_lastpost'])) . '