1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| <?php
if( isset($_GET['idList']) && is_numeric($_GET['idList']) ) {
$idList = $_GET['idList'];
echo $idList.'<br/>'; //Pour verifier si le bon id du sujet et c est le bon
}
$sqlparPage = "SELECT F.membreID, F.sujetID, F.messageForum, DATE_FORMAT(F.dateMessage,'%d/%m/%y à %Hh %i') AS dateMessage, F.statut,
M.id, M.pays, M.ville, M.pseudo, M.sexe, M.photo, M.categoriemembre, S.sujet AS sujet
FROM forummessages AS F
LEFT OUTER JOIN membres As M
ON M.id = F.membreID
LEFT OUTER JOIN sujetForum As S
ON F.sujetID = S.id
WHERE F.statut =1 AND F.sujetID = $idList
ORDER BY dateMessage ASC LIMIT $limit_start, $pagination ";
$data = mysql_query($sqlparPage) or die('Erreur - table forumMessages ' . mysql_error());
$Nbre = mysql_num_rows($data);
echo 'par page'. $Nbre.'<br/>';
$tableau_res = array();
while($info = mysql_fetch_array($data, MYSQL_ASSOC)) {
$tableau_res[$info['id']] = $info;
}
print_r($tableau_res);
?> |
Partager