Sqli Error - # Of Variables Don't Match

[vikram12345]

<?php

/* create a prepared statement */

if ($stmt = $mysqli->prepare("INSERT INTO userregistry (email,password11,firstname,lastname,contact,sex,dob,active,date) VALUES (?,?,?,?,?,?,?,?,?)"))

{

 

/* bind parameters for markers */

$stmt->bind_param("sssssssss", $email , $hash, $firstname , $secondname , $contact , $sex ,$dob , $active , $date);

 

/* execute query */

$stmt->execute();

 

 

 

/* bind result variables */

$stmt->bind_result($email,$hash,$firstname,$secondname,$contact,$sex,$dob,$active,$date);

$stmt->fetch();

 

/* close statement */

$stmt->close();

}

 

/* close connection */

$mysqli->close();

?>

 

 

Well this is the code I've written to enter the above fields into a DB

 

I keep getting the error

 

 

Warning: mysqli_stmt::bind_result(): Number of bind variables doesn't match number of fields in prepared statement in D:\xampp\htdocs\bullet2\sqlienterintodb.phpon line 15

 

 

Any ideas ??

[requinix]

INSERT queries don't return resultsets.

[vikram12345]

INSERT queries don't return resultsets.

 

slashed those statements out , works fine now. thx a lot