PHP - Random number selector

miseria · 12-18-2005, 02: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, 05: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

miseria · 12-18-2005, 06: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, 07: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?

miseria · 12-18-2005, 10:14 AM

The number is just an id

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

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

12-18-2005, 02:11 AM	#1 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	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 __________________ !!!!!!! see something you like? Accepting offers for great affiliate websites !!!!!!! Free Databases for your Website \| All Things Playstation 3 Website Design Books \| Music While You Work? \| Computer Gadgets

12-18-2005, 06:56 AM	#3 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	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. __________________ !!!!!!! see something you like? Accepting offers for great affiliate websites !!!!!!! Free Databases for your Website \| All Things Playstation 3 Website Design Books \| Music While You Work? \| Computer Gadgets

12-18-2005, 10:14 AM	#5 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	The number is just an id __________________ !!!!!!! see something you like? Accepting offers for great affiliate websites !!!!!!! Free Databases for your Website \| All Things Playstation 3 Website Design Books \| Music While You Work? \| Computer Gadgets

12-18-2005, 04:44 PM	#6 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,223 306.40 NP$ (Donate)	Can you clarify what you are looking for so I can help? __________________ All bids are valid for 24 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 01:39 AM
Googlism - What does google think of you?	deadserious	The Break Room	55	12-15-2005 09:09 AM
appraise please	Complete Hostings	Domain Appraisals	2	01-19-2005 03:03 PM

12-18-2005, 05:25 AM	#2 (permalink)
mch NamePros Regular Join Date: Nov 2005 Location: EU Posts: 248 99.25 NP$ (Donate)	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)