';
include("debug_connexion_membre.php");
echo '
';
include("include_menu.php");*/
echo '';
include("include_menu.php");
echo '
';
include("connexion_membre.php");
echo '
';
echo '
';
include("include_barre_login.php");
echo '
';
echo '
| |
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);
$str_utf = utf8_encode($row['cat_name']);
echo '
|
|
Par: ';
echo $posts_row['user_name'];
echo '
';
echo date('d-m-Y H:i:s', strtotime($topicrow['topic_date'])) ;
// echo '
// 04:02 ';
echo '
|
0 |
0 |
';
}
?>
