From b13221d3d3c98912e130c33c725d7274cda5b27d Mon Sep 17 00:00:00 2001 From: Carson Fleming Date: Fri, 17 Feb 2017 00:18:29 -0500 Subject: Restyled a lil --- dash/ads.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'dash/ads.php') diff --git a/dash/ads.php b/dash/ads.php index 97bfa3e..96f05cb 100644 --- a/dash/ads.php +++ b/dash/ads.php @@ -6,14 +6,14 @@ $adid = intval($_GET['id']); if ($adid < 1) fatal('No ad ID has been provided. You must have reached this page in error.'); $title = 'Ad / Bulletin'; require('header.php'); -$result = $db->query('SELECT ads.id, ads.title, ads.pay, ads.time, ads.location, ads.description, users.name, users.email, users.phone, users.picture, users.bio, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads INNER JOIN users ON users.id = ads.uid LEFT JOIN ratings ON ratings.rated = ads.uid WHERE ads.id = '.$adid.' LIMIT 1') or dash_fatal($db->error); +$result = $db->query('SELECT ads.id, ads.uid, ads.title, ads.pay, ads.time, ads.location, ads.description, users.name, users.email, users.phone, users.picture, users.bio, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads INNER JOIN users ON users.id = ads.uid LEFT JOIN ratings ON ratings.rated = ads.uid WHERE ads.id = '.$adid.' LIMIT 1') or dash_fatal($db->error); if ($result->num_rows < 1) dash_fatal('No ad with this ID has been found.'); $row = $result->fetch_assoc(); $result->free(); ?>
-

+

Pays $

at

@@ -28,7 +28,7 @@ if (is_null($row['picture'])) else echo ' Profile Picture'.PHP_EOL; ?> -

+

-- cgit v1.2.3