random values from mysql

Kiril_cvetkov

Hi i got one problem in php/mysql.
Example :
i am getting three data from mysql
1) "Kiril"
2) "Alexander"
3) "Tose"
example

$names.=$row['name']."<br/>"; 

and $names= Kiril Alexander Tose
i want to make the names to appear randomly 
example :
The first time $names=Kiril
seccont time $names= Alexander
third time $names = Tose

I have idea on the random function with setting the info in ARRAY but i don't know how the data in mysql to set in array with php
ANY HELP? please 🙂

_uk_stuff

I have never tried this but apparently the quickest and easiest method is to order by rand() i.e.

SELECT name FROM table ORDER BY RAND() LIMIT 0,1;

This would randomly return a single name form the table.

bradgrafelman

[uk]stuff wrote:
the quickest and easiest method is to order by rand()

Thread moved to Database forum where, incidentally, there is a stickied thread labeled Fast Random Results - "ORDER BY RAND()" is bad