Posted by Stefan Rybacki on 01/10/06 13:29

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

J.O. Aho wrote:
>...
> This don't fit the OP, as instance with a higher Rated_Sum should be picked
> more often than one with a low value, the way you suggest here would give each
> row the same chance to be in the top of the list.

Correct.

>
> If wanting to get the results as in the first post, then procedure (mysql5) is
> the only way to get it, without using help of PHP, if not be that strict, then
> you can do it with subselects (mysql4) as Stefan suggested.

What do you mean by strict. Don't I get the same distribution like your
procedure except the fact of multiple entries having the same rated value?

Regards
Stefan

>
>
> //Aho

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1rc2 (MingW32)

iD8DBQFDw5qTyeCLzp/JKjARAn3SAJkBOmDXUEj11M7E0cCt5vdkowxOtgCbBNxt
tosLvZHOLY7NfUT73Ik7F1U=
=gfnL
-----END PGP SIGNATURE-----

[Back to original message]