diff options
| author | cflem <carson.fl3ming@gmail.com> | 2016-12-29 22:39:28 -0700 |
|---|---|---|
| committer | cflem <carson.fl3ming@gmail.com> | 2016-12-29 22:39:28 -0700 |
| commit | 7bcbd5358ccf4332f554bdc510ed580354f78ec2 (patch) | |
| tree | ed8dde775fd0864e4d89c65ab44a477e0002308d /dash/ads.php | |
| parent | ce95a05bf620fcb00708d37415e256773789a2cb (diff) | |
| download | bulletin-7bcbd5358ccf4332f554bdc510ed580354f78ec2.tar.gz | |
Selected ads.bio as well
Diffstat (limited to 'dash/ads.php')
| -rw-r--r-- | dash/ads.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dash/ads.php b/dash/ads.php index a86c789..24693e9 100644 --- a/dash/ads.php +++ b/dash/ads.php @@ -6,7 +6,7 @@ $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.title, ads.pay, ads.time, ads.location, ads.description, users.name, users.email, users.phone, users.picture, 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 fatal($db->error); +$result = $db->query('SELECT 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 fatal($db->error); if ($result->num_rows < 1) fatal('No ad with this ID has been found.'); $row = $result->fetch_assoc(); ?> |