Manage Rants
fetchColumn('SELECT COUNT(id) FROM rant') / $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 );
?>
| Rant # |
Author |
Title |
Status |
Published On |
Excerpt |
|
|
|
>
| id; ?> |
name; ?> |
title; ?> |
status; ?> |
published)); ?> |
body,185); ?> |
id . '">View'; ?> |
Edit |
Delete |