'; if(isset($_GET['p'])) $page=(int)$_GET['p']; else $page=1; $next_page=$page+1; $max_result=20; $start=($page-1)*$max_result; $stmt = $db_PDO->prepare("SELECT C.*,V.note,V.ratingcomment,M.avatar FROM collection C INNER JOIN membres M ON C.pseudo=M.pseudo LEFT JOIN vote_album V ON (C.id_album=V.id_album AND C.pseudo=V.pseudo) WHERE C.id_album=:id_album ORDER BY C.pseudo LIMIT :start,:max"); $stmt->bindValue(':id_album', $id_album, PDO::PARAM_INT); $stmt->bindValue(':start', $start, PDO::PARAM_INT); $stmt->bindValue(':max', $max_result, PDO::PARAM_INT); $stmt->execute(); // echo "FOUND ".$stmt->RowCount(); if($stmt->RowCount()==$max_result) ///we assume there is more to load echo ''; $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach($rows as $ligne) { extract($ligne); if($note) $note="$note/20"; else $note=""; // echo $pseudo; echo ''; // if($id_chro) // echo "