Get random stuff from the DB?

[unknowngiver]

Hey
i have this code which alwayz gets the FIRST three matches...is there way of making it so it gets RANDOM 3 ?

<?
$country = $_GET['country'];
$searchpass = $_GET['searchpass'];
$dbusername="zubair";
$dbpassword="";
$database= "z_game";
if ($searchpass == "aa") {
    mysql_connect(localhost, $dbusername, $dbpassword);
    @mysql_select_db($database) or die("Unable to select database");
    $sql = mysql_query("Select * From user where country  = '".$country."' LIMIT 3")  ;

    while ($row = mysql_fetch_assoc($sql)) {
        	echo $row['username'] . "\n" ;
echo "?\n";
	  	echo $row['health'].  "\n" ;
echo "?\n";
		echo $row['level']. "\n";
echo "?\n";
	      echo $row['money']. "\n";
echo "?\n";
    }
}
else {
echo "error\n";
}
?>

 

[Dan]

$sql = mysql_query("SELECT * FROM user WHERE country = '".$country."' ORDER BY RAND() LIMIT 3");

 

[Eric]

$sql = mysql_query("SELECT * FROM user WHERE country = '".$country."' ORDER BY RAND() LIMIT 3");

 

[lpxxfaintxx]

lol, Dan Friedman and SecondVersion posted the exact same thing.

 

[apexad]

lol, Dan Friedman and SecondVersion posted the exact same thing.

Must mean that it works, and is the right way to do it then

It's interesting too, because this will really help me with www.restaurantselector.net. I was using arrays and php's rand() function, but I think I will switch to this, make it much easier. rep added to these 2 guys from me!

 

[Eric]

Last edited by Dan Friedman : Today at 06:57 PM.

Why the edit dan? :p

 

[Dan]

I think mine was right to begin with.. I'll test what I had first. :X

edit: nope. :0 but my post is still before SV's. So I win. (.. waits for some edits..)