Select random

[NSA]

Hello,

I'm trying to get MySQL to select 4 random people from a database each time the page is refreshed but I'm not sure how I can accomplish this.

Can someone please help?

Thanks.

 

[Ecko]

Show table structure or the query you currently have first, then we can know the best way to do this. I would say use ORDER BY RAND() in the SELECT statement, but that is inefficient as you waste resources creating a temporary table.

 

[NSA]

I'm using the Phoenix database and I want to select 4 random users from the users table.

 

[Kaz]

Funnily enough i have just implemented this onto my site, you will need to change it up abit as i have just copied the code from my script

$getRandUser = $db->query("SELECT * FROM users ORDER BY RAND() LIMIT 4");
while($getUser = $db->fetch_array($getRandUser)) {
echo $getUser['username'];
}

Then obviously where you echo it, you can have your div or w/e you want to display

 

[Weasel]

The above script from Kaz works like a charm, but if you are using RevCMS, make sure you change $db-> with $engine->

 

[Kaz]

The above script from Kaz works like a charm, but if you are using RevCMS, make sure you change $db-> with $engine->

Or if you are not using any structure what so ever you will need to replace it with the default mysql_query etc...

 

[NSA]

Thank you very much, Kaz!

 

[Kaz]

Thread closed,

Issue resolved