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 GROUP BY ads.id LIMIT ' . 10*($page-1) . ', 10') or fatal($db->error); while ($row = $result->fetch_assoc()) { ?>

Uncategorized

'.PHP_EOL; else echo '

'.htmlentities($row['cat_name']).'

'.PHP_EOL; ?>

Employer Not Rated

'.PHP_EOL; else echo '

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

'.PHP_EOL; ?>

Pays $

[...]

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