diff options
| author | cflem <carson.fl3ming@gmail.com> | 2017-01-01 19:46:20 -0700 |
|---|---|---|
| committer | cflem <carson.fl3ming@gmail.com> | 2017-01-01 19:46:20 -0700 |
| commit | be8e64ca785c9281d09b42aeaa917e8a1673af42 (patch) | |
| tree | 3f0a7c6675d2e1fdf7b9653f9e293c2aa23b72c7 /dash/dash_employer.php | |
| parent | d8543707426d6a4645c270929f999df8209bb587 (diff) | |
| download | bulletin-be8e64ca785c9281d09b42aeaa917e8a1673af42.tar.gz | |
Moved ad displaying to dash_functions.php; finished settings.php
Diffstat (limited to 'dash/dash_employer.php')
| -rw-r--r-- | dash/dash_employer.php | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/dash/dash_employer.php b/dash/dash_employer.php index 28c5ed1..78debfd 100644 --- a/dash/dash_employer.php +++ b/dash/dash_employer.php @@ -2,8 +2,10 @@ if (!defined('HEIRARCHY')) die; $title = 'Dashboard / Bulletin'; require('header.php'); -?> - <p></p> -<?php +$page = 1; +if (!empty($_GET['p'])) $page = max(1, intval($_GET['p'])); +$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated GROUP BY ads.id LIMIT ' . $b_config['ads_per_page']*($page-1) . ', '.$b_config['ads_per_page']) or fatal($db->error); +while ($row = $result->fetch_assoc()) draw_ad($row); +$result->free(); require('footer.php'); ?> |