code question

[The_Net_Muppet]

does this look ok?

I want it to see if teh user account is disabled where the field = Yes

}

 $sql_disabled = ("SELECT * FROM $users_profiles WHERE
 username='$PHP_AUTH_USER' && account_disabled
 ='$account_rows'");
 


// execute the sql query and get result
    $sql_disabled_query = mysql_query($sql_disabled)
        or die("Could not match!");

$account_rows = mysql_num_rows ($sql_disabled_query);
if ($account_rows == 'Yes')
 {
 echo "Your account is disabled";
 exit;
 } else {

} 

[Krucifyx]

Umm, a lot of work needed on this one

First let me point out your problems. In your query, is the variable $account_rows set to anything? If you're trying check it against 'Yes', that needs to be 'Yes'.

Secondly,
$account_rows = mysql_num_rows ($sql_disabled_query);

That returns the number of rows returned by the query, so there is no chance it'll ever equal 'Yes' for "if ($account_rows == 'Yes')" to ever work.

if (mysql_query("SELECT * FROM $users_profiles WHERE
username='$PHP_AUTH_USER' && account_disabled='Yes'");
) {
     echo "Your account is disabled";
     exit;
} 

That should work just fine