Posted By

BFTrick on 09/30/09

Tagged

Viewed 922 times

Favorited by 1 user(s)

/ Published in: MySQL

Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT * FROM Table ORDER BY Rand( ) * ( 1 / Weight )

Comment:

You need to login to post a comment.