MySQL Help

[NSA]

Hello!

I am trying to make a script that will select 5 random people from the database each time the page is refreshed.

For instance say there was 100 people in a database with premium = 1
I want MySQL to select 5 random of them each time the page is loaded so it always displays different ones

Can anyone help?

 

[Deion]

What are you trying to make it select? motto's, names, coins, ect

 

[NSA]

I want it to select VIP user's.

 

[Deion]

I want it to select VIP user's.

I understand that, but what exactly do you want it to select? Their avatar's? Names? Motto? Coins? Pixels? Points?

 

[NSA]

I just want to select the VIP user's & if they are VIP to be shown on a page...

 

[Deion]

I just want to select the VIP user's & if they are VIP to be shown on a page...

You don't understand what MySQL fetching is, i'm asking what do you want it to select, just random VIP's no names? Random VIP's with their names and motto's? Random VIP's with their names, motto's, credits, ect?

 

[NSA]

I want VIP's with Name's, Coins, Last Login & If they're online or not.

Sorry it took so long for me to understand.

 

[Tronscript]

I think this is what you want:

<?php
$LIMIT = 5; # The amount of users you want returned/
$query = mysql_query("SELECT * FROM users WHERE premium = '1' LIMIT = '" . $LIMIT . "'");
 
while($vip = mysql_fetch_assoc($query)) {
    $username = $vip['username'];
    $motto = $vip['motto'];
    $coins = $vip['coins'];
    $isOnline = $vip['online'];
    $lastLogin = date('F j @ g:i', $vip['last_online']);
    switch($isOnline) {
        case 1:
            return $username . ' is currently online!';
        break;
        case 0:
            return $username . ' is currently offline.';
        break;
    }
}
?>

The online part may be wrong, because I forgot what Phoenix calls the column.