From 147eadd2c2bb6c8c2c9e238a82296c8a840c4aa8 Mon Sep 17 00:00:00 2001
From: Cflip <36554078+cflip@users.noreply.github.com>
Date: Sun, 24 Jan 2021 14:14:05 -0700
Subject: Create function to display threads

---
 index.php | 10 +++-------
 1 file changed, 3 insertions(+), 7 deletions(-)

(limited to 'index.php')

diff --git a/index.php b/index.php
index fabec83..3672dbe 100644
--- a/index.php
+++ b/index.php
@@ -57,24 +57,20 @@ include_once 'header.php';
 	<table>
 		<tr>
 			<th class="left">Latest Threads</th>
-			<th class="right">Categories</th>
+			<th class="right">Latest Post</th>
 		</tr>
 <?php
 	include_once 'includes/db_inc.php';
+	include_once 'includes/functions_inc.php';
 
 	$sql = "SELECT thread_id, thread_subject, thread_date, user_id, user_name, cat_id, cat_name FROM threads JOIN users ON thread_author = user_id JOIN categories ON thread_cat = cat_id ORDER BY thread_id DESC LIMIT 5";
 	$result = mysqli_query($dbc, $sql);
 
 	if (!$result) {
 		die('Error trying to display threads: ' . mysqli_error($dbc));
-	} 
-
-	while ($row = mysqli_fetch_assoc($result)) {
-		echo '<tr><td class="left">';
-		echo '<h4><a href="thread.php?id=' . $row['thread_id'] . '">' . $row['thread_subject'] . '</a></h4>';
-		echo '<small>by <b><a href="user.php?id=' . $thread['user_id'] . '">' . $row['user_name'] . '</a></b> on ' . date('M d, Y', strtotime($row['thread_date'])) . '</small></td><td class="right">Posted in <a href="category.php?id=' . $row['cat_id'] . '">' . $row['cat_name'] .'</a></td></tr>';
 	}
 
+	display_threads($dbc, $result, true);
 	mysqli_free_result($result);
 ?>
 	</table>
-- 
cgit v1.2.3