Checking mySQL DB?

[Kyle123]

Okay I need some help.

I want to check a MySQL DB and then if it says 0 then don't do anything if it says anything else echo out what's there.

I have tried for about a hour now.

 

[ignace]

Please post your code.

[Kyle123]

<?
include("config.php");
if(isset($_GET['username']) and ($_GET['password']) and ($_GET['hwid'])){
$username = $_GET['username'];
$password = md5($_GET['password']);

$query=mysql_query("SELECT banned FROM `members` WHERE `login`='$username'");
$result = mysql_num_rows($query);
$outcome = ($result > 0) ? 'true' : 'false';
echo $outcome;
}
?>

 

I think the last bit is all wrong.

[ignace]

Try this:

 

include("config.php");
if(isset($_GET['username']) and ($_GET['password']) and ($_GET['hwid'])){
   $username = $_GET['username'];
   $password = md5($_GET['password']);

$sql = "SELECT banned FROM `members` WHERE `login`='$username'";
$query=mysql_query($sql) or exit("ERROR: " . mysql_error() . "<br>QUERY: " . $sql);
$result = mysql_num_rows($query);
$outcome = ($result > 0) ? 'true' : 'false';
echo $outcome;
}

[Kyle123]

Okay I have done it now.

Noob way but it works.

   $query = mysql_query("SELECT * FROM `members` WHERE login='$username'");
while($row = mysql_fetch_array($query)){
if($row['banned']=="0"){
}else{
echo $row['banned'];
die();
}
}

[Maq]

Kyle, in the future, please place

OR

tags around your code.  You also should not be using short tags, use <?php.