Limiting Mysql output

[unknowngiver]

Hey
Code:

<?
$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."' ORDER BY RAND() 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";
}
?>

i am trying to get it to output ONLY the results where health and money are > 20
what do i do? can i just put it in in the QUERY ?

 

[Eric]

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

?

 

[Dan]

<?
$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."' ORDER BY RAND() LIMIT 3")  ;

    while ($row = mysql_fetch_assoc($sql)) {
        if ($row['health'] > 20 && $row['money'] > 20) {
            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";
    }
}
?>

SV, don't know if you can do that, so I did it this way..

Blah, don't use this. If you get 3 results and it doesn't display them.. :/

 

[Eric]

Yes, you can.

 

[unknowngiver]

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

?

its getting health and money from the db right?

 

[Dan]

It's getting everything.

SELECT *