XtGem Forum catalog

Hello '.htmlentities($_SESSION['user_name']).'
'; echo 'Date - '.date("d/m/Y").'

'; } $sql = "SELECT categories.cat_id, categories.cat_name, categories.cat_description, COUNT(topics.topic_id) AS topics FROM categories LEFT JOIN topics ON topics.topic_id = categories.cat_id GROUP BY categories.cat_name, categories.cat_description, categories.cat_id ORDER BY categories.order_id"; $result = mysql_query($sql); if(!$result) { echo 'The categories could not be displayed, please try again later.'; } else { if(mysql_num_rows($result) == 0) { echo 'No categories defined yet.'; } else { //prepare the table echo '

Select Category

'; while($row = mysql_fetch_assoc($result)) { //Count number of topic in each category $topiccou = "SELECT topic_id, topic_subject, topic_date, topic_cat FROM topics WHERE topic_cat = " . $row['cat_id'].""; $couresult = mysql_query($topiccou); $topiccount = mysql_num_rows($couresult); echo '

'; echo '' . $row['cat_name'] . ' ['.$topiccount.']
' . $row['cat_description']; //fetch last topic for each cat $topicsql = "SELECT topic_id, topic_subject, topic_date, topic_cat FROM topics WHERE topic_cat = " . $row['cat_id'] . " ORDER BY topic_date DESC LIMIT 1"; $topicsresult = mysql_query($topicsql); if(!$topicsresult) { echo 'Last topic could not be displayed.'; } else { if(mysql_num_rows($topicsresult) == 0) { echo '
- No topics'; } else { while($topicrow = mysql_fetch_assoc($topicsresult)) echo '
- ' . $topicrow['topic_subject'] . ' at ' . date('d-m-Y', strtotime($topicrow['topic_date'])); } } echo '

'; } } } include 'footer.php'; ?>