Can't update database

[BelowZero]

I'm trying to update my database so that if someone enters an e-mail address that doesn't exist, the program updates the database with the new address. I've tested everything and $result returns the correct data every time (0 or 1) but if the address doesn't exist, nothing gets updated. I know I'm missing something, just not sure what it is...

{
$result = mysql_query("
SELECT * 
FROM PlayerInfo
WHERE Player_Email = '$playeremail'");

IF($result) { 

     IF (mysql_num_rows($result) = 0)
{
//Insert into database: new e-mail address...
}
}

I've also tested the insert into statement and it works, so that's not the issure.  Any help appreciated. Thanks.

[Muddy_Funster]

     IF (mysql_num_rows($result) = 0)

 

wrong number of = , you need at least 2

[BelowZero]

IF (mysql_num_rows($result) == 0)

 

returns:

Fatal error: Can't use function return value in write context in...

[chriscloyd]

Then do this and see if it works

$Num = mysql_num_rows($result);
if ($Num == 0) {
     //code here
}

[BelowZero]

Yes, that did it!

 

Thanks.