Hello, I expect it returns to either -1 or 1 but boolean.
$dbc = mysqli_connect("localhost", "root", "","test_site") or die ("SQL could not connect to database!.");
$query = "INSERT INTO user_accounts(member_type,username,password,name,email,country)
VALUES ('$membertype','$username','$password','$name','$email','$country')";
$result = mysqli_query($dbc, $query);
$registered =mysqli_affected_rows($result);
if($registered>0)
echo "Registered Successfully.";
else
echo "Your registration is unsuccessful.";
mysqli_close($dbc);
Warning: mysqli_affected_rows() expects parameter 1 to be mysqli, boolean...