Top 10 Rating

AndrewB · Post by **AndrewB** » Fri Sep 26, 2003 3:03 pm

How would I add the rating to the Top 10 section?

I would like a way for it to show 5 stars or whatever the rating is.

Post by **Thorsten** » Fri Sep 26, 2003 3:40 pm

Hi Andrew,

the SQL-Query should look like:

SELECT DISTINCT faqdata.id, faqdata.lang, faqdata.active, faqdata.rubrik, faqdata.thema, ( faqvoting.vote / faqvoting.user ) AS num, faqvoting.user FROM faqdata, faqvoting WHERE faqdata.id = faqvoting.artikel GROUP BY faqdata.id ORDER BY num LIMIT 10

The rest is simple PHP.

bye
Thorsten

AndrewB · Post by **AndrewB** » Fri Sep 26, 2003 4:01 pm

Thanks for the SQL.

Simple for you maybe...

I will have fun trying this

Post by **Thorsten** » Fri Sep 26, 2003 4:03 pm

Hi Andrew,

just look in the file admin/stat.ratings.php, you can use a lot of stuff from this file.

bye
Thorsten