Two php/mysql bugs that need fixing on website

IN PROGRESS
Bids
18
Avg Bid (USD)
$91
Project Budget (USD)
$30 - $250

Project Description:
I have a website where users can earn points from each other for watching videos.
The php script determines the order of the videos by who is paying out the most points
per view which the maximum is 9.

All videos paying out 9 go before videos that are paying out 8 and so on.
I want the script to still show the videos with the most points paid out first ,
but i want the videos to be randomized when grabbed from mysql.

The problem i'm facing is that some users have a lot of videos and when the
viewer gets to their videos they are forced to watch hundreds of the same user
videos in a row.

Grabbing the videos by highest payouts while randomizing the user.

Skills required:
MySQL, PHP
Additional Files: phpscreenshot.jpg
Hire userctrl
Project posted by:
userctrl United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 200
in 5 days
Hire rajeshsonisl
$ 100
in 1 days
$ 100
in 3 days
$ 49
in 3 days
$ 200
in 3 days
$ 50
in 0 days
$ 80
in 2 days
$ 55
in 3 days
$ 50
in 3 days
$ 45
in 2 days