PHP - Random number selector

Encenta.com · 12-18-2005, 03:11 AM

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 · 12-18-2005, 06:25 AM

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

Encenta.com · 12-18-2005, 07:56 AM

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 · 12-18-2005, 08:41 AM

Quote:

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?

Encenta.com · 12-18-2005, 11:14 AM

The number is just an id

jdk · 12-18-2005, 05:44 PM

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

12-18-2005, 03:11 AM	THREAD STARTER #1 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	PHP - Random number selector 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 __________________ Encenta - Amazon Associates CMS

12-18-2005, 07:56 AM	THREAD STARTER #3 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	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. __________________ Encenta - Amazon Associates CMS

12-18-2005, 11:14 AM	THREAD STARTER #5 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	The number is just an id __________________ Encenta - Amazon Associates CMS

12-18-2005, 05:44 PM	#6 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,492	Can you clarify what you are looking for so I can help? __________________ All offers are valid for 12 hours unless otherwise stated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 02:39 AM
Googlism - What does google think of you?	deadserious	The Break Room	55	12-15-2005 10:09 AM
appraise please	Complete Hostings	Domain Appraisals	2	01-19-2005 04:03 PM

12-18-2005, 06:25 AM	#2 (permalink)
mch NamePros Regular Join Date: Nov 2005 Location: EU Posts: 248	I can't give you the script but I found an MSSQL script that might help. http://www.sqlteam.com/item.asp?ItemID=802

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)