php / mysql best way to make this script?

  • Thread starter Thread starter Cazpa
  • Start date Start date
C

Cazpa

Guest
Hi

I have just made a script / website ( http://statusupdates.info ) and need to make a script to show the top rated updates. The thing is that the updates are in one table and the rating is in another table and I need to combine two queries to get the info out

The update table has the following info:

id (auto_increment)
quote
the user
the category
the timestamp
and some other info

and the rating has

users ip
rating
id (same as the updates id)

How can I make a limited loop (top ten) using info from both tables?

please bear in mind that I need to also work out the average rating first to get the top ten then pull the info from the updates table using this.

Thank you in advance
 
Back
Top