diff --git a/manage-pages.php b/manage-pages.php index 3376f33..f2d3c96 100644 --- a/manage-pages.php +++ b/manage-pages.php @@ -20,7 +20,7 @@ $perpage = 15; $start = ($page - 1) * $perpage; $total = ceil( $dbConnection->fetchColumn('SELECT COUNT(url_name) FROM static_page') / $perpage ); -$pages = $dbConnection->fetchAll('SELECT url_name, pubdate, status, title, body FROM static_page ORDER BY url_name ASC LIMIT ?, ?', array($start, $perpage)); +$pages = $dbConnection->fetchAll('SELECT url_name, pubdate, status, title, body FROM static_page ORDER BY url_name ASC LIMIT ?, ?', array($start, $perpage), array(PDO::PARAM_INT, PDO::PARAM_INT)); pagination( $page, $total ); diff --git a/manage-rants.php b/manage-rants.php index 31b74f7..8ddb8ad 100644 --- a/manage-rants.php +++ b/manage-rants.php @@ -20,7 +20,7 @@ $perpage = 15; $start = ($page - 1) * $perpage; $total = ceil( $dbConnection->fetchColumn('SELECT COUNT(id) FROM rant') / $perpage ); -$rants = $dbConnection->fetchAll('SELECT r.id, UNIX_TIMESTAMP(r.published) AS published, c.name, r.title, t.body, r.status FROM rant r JOIN contributor c ON r.author = c.id ORDER BY r.id DESC LIMIT ?, ?', array($start, $perpage)); +$rants = $dbConnection->fetchAll('SELECT r.id, UNIX_TIMESTAMP(r.published) AS published, c.name, r.title, r.body, r.status FROM rant r JOIN contributor c ON r.author = c.id ORDER BY r.id DESC LIMIT ?, ?', array($start, $perpage), array(PDO::PARAM_INT, PDO::PARAM_INT)); pagination( $page, $total );