Mysql affected rows related question

PHP
1

Hai folks

why my script does not show “Record already exist” message when a record already exist?

$query="SELECT * FROM by_nation WHERE pid='$pid' and nation='$nation' and required='$required'";
if ($result=mysql_query($query) or die (mysql_error()));
if(mysql_num_rows($result)<1){
	$query = "INSERT into by_nation VALUES (
			'$pid',
			'$nation',
			'$required',
			'$achived',
			'$balance'
			)";
			
	if ($result=mysql_query($query) or die (mysql_error()));
	if(mysql_affected_rows()>0){
	   echo "Record added successfully";
	}else{
	   echo "Record already exist.";
	}
}
2

sorry folks,
i messed up a bit and i have now corrected the code and works fine.

if(mysql_num_rows($result)<1){
	$query = "INSERT into by_nation VALUES (
			'$pid',
			'$nation',
			'$required',
			'$achived',
			'$balance'
			)";
			
	if ($result=mysql_query($query) or die (mysql_error()));
    if(mysql_affected_rows()>0){
	   echo "Record added successfully";
    }else{
	   echo "Record cannot be updated.";
	}

}else{
   echo "Record already exist";
}