You'd probably be better off having rank and votes fields in the actual
album_detail table. Whether you choose to maintain the individual votes in
the album_ranks is another story. Let's say you rank an album from 1 to
10 - the rank would then be calculated like this:
$uservote = 8.5 // this is
Dear Adam,
I have faced the same problem a while ago and I didn't receive any kind of
answer regarding doing this with MySQL in any discussion list at all. I had
to create a function using PHP to do the hard job and the ranking position
was created on the fly (using your example, I wouln't need t