add 'empty category' message

2 files changed, 10 insertions, 3 deletions

diff --git a/index.php b/index.php
index 01acd33..2a1c633 100644
--- a/index.php
+++ b/index.php
@@ -41,8 +41,13 @@ include_once 'header.php';
 		echo '<tr><td class="left">';
 		echo '<h4><a href="category.php?id=' . $row['cat_id'] . '">' . $row['cat_name'] . '</a></h4>';
 		echo $row['cat_description'];
-		echo '</td><td class="right">' . $thread['thread_subject'] . '<br>';
-		echo '<small>by <b>' . $thread['user_name'] . '</b></small></td></tr>';
+		if ($thread) {
+			echo '</td><td class="right">' . $thread['thread_subject'] . '<br>';
+			echo '<small>by <b>' . $thread['user_name'] . '</b></small></td></tr>';
+		} else {
+			$no_threads_msg = 'There are no threads in this category yet.';
+			echo '</td><td class="right"><small>'. $no_threads_msg .'</small></td>';
+		}
 	}
 
 	mysqli_stmt_close($stmt);
@@ -75,4 +80,4 @@ include_once 'header.php';
 	</table>
 <?php
 include_once 'footer.php';
-?>
\ No newline at end of file
+?>
diff --git a/setup.sql b/setup.sql
index f51250b..5934e3e 100644
--- a/setup.sql
+++ b/setup.sql
@@ -37,3 +37,5 @@ ALTER TABLE threads ADD FOREIGN KEY(thread_cat) REFERENCES categories(cat_id) ON
 ALTER TABLE threads ADD FOREIGN KEY(thread_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
 ALTER TABLE posts ADD FOREIGN KEY(post_thread) REFERENCES threads(thread_id) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE posts ADD FOREIGN KEY(post_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
+
+INSERT INTO categories (cat_name, cat_description) VALUES ("General", "Discussion of anything that doesn't fit in the other categories");