diff options
| author | Carson Fleming <cflems@cflems.net> | 2017-03-16 21:28:51 -0700 |
|---|---|---|
| committer | Carson Fleming <cflems@cflems.net> | 2017-03-16 21:28:51 -0700 |
| commit | ca71122b9a343bacd6c0b2933ddf295ebcff4f07 (patch) | |
| tree | 595a998026e0182fc04c4d7ecc7cbc6e14a70455 /dash/dash_employee.php | |
| parent | 3d0d3a86106ece4ea298ab2f262b3af5ff8a7728 (diff) | |
| download | bulletin-ca71122b9a343bacd6c0b2933ddf295ebcff4f07.tar.gz | |
Final candidate for alpha version, moving to beta soon
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 df7112d..2c507c2 100644 --- a/dash/dash_employee.php +++ b/dash/dash_employee.php @@ -15,7 +15,7 @@ $result->free(); </form> <?php $catstr = empty($_GET['cat']) ? '' : ' AND cat = '.intval($_GET['cat']); -$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'.$catstr.' GROUP BY ads.id LIMIT 0, '.$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'.$catstr.' GROUP BY ads.id ORDER BY ads.id DESC LIMIT 0, '.$b_config['ads_per_page']) or fatal($db->error); while ($row = $result->fetch_assoc()) draw_ad($row); $result->free(); require('footer.php'); |