En cours de développemment ...

Section Forum

Forum Dernier Post Topics Posts '; /*for($i = 0 ; $i <= 5 ; $i++) {*/ while($row = mysql_fetch_assoc($result)) { $topicsql = "SELECT topic_id, topic_subject, topic_date, topic_cat, topic_by FROM topics WHERE topic_cat = " . $row['cat_id'] . " ORDER BY topic_date DESC LIMIT 1"; $topicsresult = mysql_query($topicsql); $topicrow = mysql_fetch_assoc($topicsresult); //echo "+++ " .$topicrow['topic_by']; //echo '' . $topicrow['topic_subject'] . ' //$posts_sql = "SELECT user_name FROM users WHERE "; $id = $topicrow['topic_id']; $posts_sql = "SELECT posts.post_topic, posts.post_content, posts.post_date, posts.post_by, users.user_id, users.user_name FROM posts LEFT JOIN users ON posts.post_by = users.user_id WHERE posts.post_topic = '".$id."' "; $posts_result = mysql_query($posts_sql); $posts_row = mysql_fetch_assoc($posts_result); echo '

' . $row['cat_name'] . '

'; echo $topicrow['topic_subject'] ; echo '

Par: '; echo $posts_row['user_name']; echo '

'; echo date('d-m-Y H:i:s', strtotime($topicrow['topic_date'])) ; // echo ' // 04:02 '; echo '

692 2,818 '; } ?>