[SOLVED] Randomly Select a Row

[codexx]

Hey Everyone,

 

I have to do a script where a user fights an enemy. There are many to choose from all for differn't levels in which the user is at.

 

I need to first (SELECT * FROM creep_data WHERE minlvl < '".$user[lvl]."' AND maxlvl > '".$user['lvl']."'")

 

After I have all of the possible monsters I need to randomly select one of these and retrieve all of the data about it.

 

How could I go about doing this ?

 

Thanks in advance,

Sean

[mmarif4u]

use:

order by id rand() in ur query.

Here id primary key. any thing it can depends on ur table structure.

[codexx]

Primary key is ID.

 

When I try $creepinfo = mysql_query ("SELECT * FROM creep_data WHERE minuserlvl < '".$user[lvl]."' AND maxuserlvl > '".$user['lvl']."' ORDER BY id rand()");

 

it gives me an error. Is there anyway I could get all off the possible creeps then randomly select on in an array?

[mmarif4u]

What is that error.

[codexx]

Error reporting is turned off so i'm not sure the exact error. Its just saying that its an invalid SQL statement when I check it.

[hyeteck]

im still trying to get a hang of this php stuff myself, but try this, it should work.

 

$creepinfo = mysql_query ("SELECT * FROM creep_data WHERE minuserlvl < '$user[\'lvl\']' AND maxuserlvl > '$user[\'lvl\']' ORDER BY id rand()");

[php_joe]

or I think you could use shuffle($creepinfo); and then use $creepinfo[0] for the enemy's information.

[sasa]

SELECT * FROM creep_data WHERE minuserlvl < '$user[\'lvl\']' AND maxuserlvl > '$user[\'lvl\']' ORDER BY rand() LIMIT 1

no id field in order

[codexx]

The last post worked Thank you!