[SOLVED] randomizing results

[ohdang888]

hey.

i am creating a gaming site.

in one section, it will display related games...

first of all, wahts the easiest way to do that?i'm thinking MYSQL might be the only way...

 

when i get the results, i want it to pick 5 random ones and put them in a random order.

 

any1 no the outline of that kind of code?

[p2grace]

Return the items from the db into an array.

 

Then use:

 

shuffle($array);

$new_array = array();

for($i=0;$i<5;$i++){
$new_array [] = $array[$i];
}

[trq]

This can all be done in your query....

 

SELECT game FROM games ORDER BY RAND(id) LIMIT 5

[ohdang888]

thorpe. i tried your way.

this is what i am getting back....

 

Unknown column 'id' in 'order clause'

 

this is my full query

$result = mysql_query("SELECT * FROM test ORDER BY RAND(id) LIMIT 5")

 

what am i doing wrong?

[revraz]

Replace id with whatever your id field name is.