[RESOLVED] Sort results by values in another table

[DigiRev]

I'm trying to order the results by values in another table.

There is one table named listings with stuff like:

id
name
description

And there are votes users leave on each listing stored in a table votes:

id
listing_id
rating (1-5)

Now, on the main page that displays the listings, there is a filter option for sorting the results by user rating. How would I do this? Can someone give me an example? It's kind of urgent...

Edit: Is this the job for a stored procedure? I don't think he has a MySQL version that supports these though and I've only read briefly on them. If there's another solution, even if it's kind of a dirty fix, that would be better.