diff options
| author | cflem <carson.fl3ming@gmail.com> | 2017-01-21 16:46:59 -0500 |
|---|---|---|
| committer | cflem <carson.fl3ming@gmail.com> | 2017-01-21 16:46:59 -0500 |
| commit | a17c35d61bcca213a810ba4abea896075647df66 (patch) | |
| tree | f3b8da3ff97791b0c0c1b28f519cd23bdb72ded5 /dash/dash_employee.php | |
| parent | 1e969333228597382b1229d4e813629f884c698d (diff) | |
| download | bulletin-a17c35d61bcca213a810ba4abea896075647df66.tar.gz | |
Created ad responses
Diffstat (limited to 'dash/dash_employee.php')
| -rw-r--r-- | dash/dash_employee.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dash/dash_employee.php b/dash/dash_employee.php index d4a3df1..795d400 100644 --- a/dash/dash_employee.php +++ b/dash/dash_employee.php @@ -4,7 +4,7 @@ $title = 'Dashboard / Bulletin'; require('header.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); +$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 WHERE ads.closed = 0 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'); |