Connecting database and html form brings an unexpected error

[Mathius]

When I try to submit my form data,I get this error, ( ! ) Parse error: syntax error, unexpected '$rnum' (T_VARIABLE) in C:\wamp64\www\web\insert.php on line 41

This is the part that seems to have an issue. Kindly help:

//prepare statements
$stmt=$conn->prepare($SELECT);
$stmt->bind_param("s", $email);
$stmt->execute();
$stmt->bind_result($email);
$stmt->store_result
$rnum = $stmt->num_rows;
 
if($rnum==0){
    $stmt->close();
    $stmt->$conn->prepare($INSERT);
    $stmt->bind_param("ssssii", $username, $password, $gender, $email, $phoneCode, $phone);
$stmt->execute();
echo "New record inserted succesfully.";

[Rabbit]

Please use code tags when posting code or formatted data.

You need to tell us which line is line 41. But it's probably line 6 or 7 above that is your line 41. You're missing a semi-colon.