PHP - Random number selector

[SiKing]

Ello. I am offering 50 NP$ to anyone who can give me a PHP/MySQL script which will:

- Select the data from a MySQL database
- Take the numbers from the 'x' row
- and then display a random name from the table according to probability of the 'x'.

Sorry, I know that isn't too clear. Basically, there is a table with rows 'x' and 'name'. If one entry (Jim) in the database has '50' in the 'x' row , and another (Paul) has '1'. The script is 50 times more likely to display 'Jim's' results.

Sorry, I know that isn't too clear. very tired

 

[mch]

I can't give you the script but I found an MSSQL script that might help.
http://www.sqlteam.com/item.asp?ItemID=802

 

[SiKing]

Thanks. However, I was looking for a MYSQL script rather than MSSQL.

I am developing something myself instead, and I just need to know how I can find all of the 'id's in a table. (For example, if I delete a row). I could use mysql_numrows, but it may include id's which do not exist. For example, it will select id's 1-50, but I may have deleted row #40.

 

[nasaboy007]

The script is 50 times more likely to display 'Jim's' results.

does that mean that ur table is a frequency table? or is the number just an id?

 

[SiKing]

The number is just an id

 

[jdk]

Can you clarify what you are looking for so I can help?