From ca71122b9a343bacd6c0b2933ddf295ebcff4f07 Mon Sep 17 00:00:00 2001 From: Carson Fleming Date: Thu, 16 Mar 2017 21:28:51 -0700 Subject: Final candidate for alpha version, moving to beta soon --- dash/dash_employer.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'dash/dash_employer.php') diff --git a/dash/dash_employer.php b/dash/dash_employer.php index d30ca04..0ae87e5 100644 --- a/dash/dash_employer.php +++ b/dash/dash_employer.php @@ -22,12 +22,12 @@ $result->free(); 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.uid = '.$b_user['id'].' AND ads.closed = 0 GROUP BY ads.id') 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.uid = '.$b_user['id'].' AND ads.closed = 0 GROUP BY ads.id ORDER BY ads.id DESC') or fatal($db->error); if ($result->num_rows < 1) draw_noads(); while ($row = $result->fetch_assoc()) draw_ad($row); $result->free(); } else { - $result = $db->query('SELECT responses.id, responses.comment, responses.uid, users.name, users.address, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM responses INNER JOIN users ON responses.uid = users.id LEFT JOIN ratings ON ratings.rated = responses.uid WHERE responses.adid = '.$view.' AND responses.matched = 0 GROUP BY responses.id') or dash_fatal($db->error); + $result = $db->query('SELECT responses.id, responses.comment, responses.uid, users.name, users.address, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM responses INNER JOIN users ON responses.uid = users.id LEFT JOIN ratings ON ratings.rated = responses.uid WHERE responses.adid = '.$view.' AND responses.matched = 0 GROUP BY responses.id ORDER BY responses.id DESC') or dash_fatal($db->error); if ($result->num_rows < 1) draw_noapps(); while ($row = $result->fetch_assoc()) draw_app($row); $result->free(); -- cgit v1.2.3