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 '.($clicks+10).', 1') or die(); if ($result->num_rows) { $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(); $db->close(); ?>