MySQL query being performed when PHP if condition not met?

Question

The script I'm using is

if($profile['username'] == $user['username']) {
    $db->query("UPDATE users SET newcomments = 0 WHERE username = '$user[username]'");
    echo "This is a test";
}

(Note that $db->query is exactly the same as mysql_query)

For some very odd reason, the MySQL query is being performed even if the defined condition is false

The "This is a test" works properly and only appears when the condition is met, but the MySQL query is performed anyway

Whats the problem with it?

Answer 1

Typically the answer to such questions is somewhere else. Maybe similar SQL code is called elsewhere?

Answer 2

Your code looks fine. Try:

echo "<pre>";
print_r($profile);
print_r($user);

and see if it is what you expected.

Answer 3

I'm having trouble believing this, either way try something like this.

$query="";
if($profile['username'] == $user['username']) {
    $query ="UPDATE users SET newcomments = 0 WHERE username = '" . $user[username] . "' "; 
    echo "This is a test";
}

echo $query;
$db->query($query);