Jump to content

ORDER BY popularity?


EchoFool

Recommended Posts

Hey,

 

 

I am wondering how to do an ORDER BY involving a seperate table so i can calculate the popularity of a given book?

 

 

 

 

My system has a book and then user votes. Such as:

 

User1 = 4 stars

User2 = 2 stars

User4 = 5 stars

 

So im trying to ORDER BY most popular from working out the average score for a given book. Is this possible with a simple ORDER BY? What would the syntax be ?

 

Link to comment
https://forums.phpfreaks.com/topic/252095-order-by-popularity/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.