prepare('SELECT blog_posts_seo.postID FROM blog_posts_seo, blog_post_cats WHERE blog_posts_seo.postID = blog_post_cats.postID AND blog_post_cats.catID = :catID'); $stmt->bindValue(':catID', $row['catID'], PDO::PARAM_INT); $stmt->execute(); $count = $stmt->rowCount(); if (empty($count)) { echo '

Aucun torrent dans cette catégorie.

'; } //pass number of records to $pages->set_total($stmt->rowCount()); $stmt = $db->prepare(' SELECT blog_posts_seo.postID, blog_posts_seo.postHash, blog_posts_seo.postTitle, blog_posts_seo.postAuthor, blog_posts_seo.postSlug, blog_posts_seo.postLink, blog_posts_seo.postDesc, blog_posts_seo.postTaille, blog_posts_seo.postDate, blog_posts_seo.postViews, blog_posts_seo.postImage FROM blog_posts_seo, blog_post_cats WHERE blog_posts_seo.postID = blog_post_cats.postID AND blog_post_cats.catID = :catID ORDER BY postID DESC '.$pages->get_limit()); $stmt->bindValue(':catID', $row['catID'], PDO::PARAM_INT); $stmt->execute(); while($row = $stmt->fetch()){ echo '

'; echo ''.html($row['postTitle']).''; echo '
Posté le '.date_fr('l j F Y à H:i:s', strtotime($row['postDate'])).' par '; $stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_post_cats WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID'); $stmt2->bindValue(':postID', $row['postID'], PDO::PARAM_INT); $stmt2->execute(); $catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC); echo html($row['postAuthor']).' dans '; $links = array(); foreach ($catRow as $cat) { $links[] = "".html($cat['catTitle']).""; } echo implode(", ", $links); echo ''; echo '

'; echo ''; echo bbcode($row['postDesc']); echo '

'; echo '

'; } echo '

'; echo $pages->page_links('c-'.html($_GET['id']).'&'); } catch(PDOException $e) { echo $e->getMessage(); } ?>