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); if ($result->num_rows < 1) fatal('No ad with this ID has been found.'); $row = $result->fetch_assoc(); ?>

Pays $

at

'.PHP_EOL; else echo ' Profile Picture'.PHP_EOL; ?>

Employer Not Rated

'.PHP_EOL; else echo '

'.intval($row['rating']).' Star Employer

'.PHP_EOL; ?>

No bio included in profile.' : htmlentities($row['bio']));?>

Respond to this Ad

Open a Chat

free(); require('footer.php'); ?>