Mysqli prepare not inserting

[AdamHull12]

Hello, I have this code

<?php
 $stmt = $db->prepare("INSERT INTO `members` (`playername`,`player_login_name`,`player_login_pass`,`my_email`,
                                           `my_gender`,`signup_IP`,`signup_time`)
                    VALUES(?,?,?,?,?,?,?)");
$stmt->bind_param("ssssssi",$_POST['email'],$_POST['email'],md5($_POST['pass']),$_POST['email'],$_POST['gender'],$_POST['REMOTE_ADDR'],time());
$stmt->execute();
$stmt->close();
?>

and i will not insert into my database. I have check the syntax and there is no error, can anyore help me

 

thanks

[Barand]

What does $stmt->error tell you?

[AdamHull12]

What does $stmt->error tell you?

Column 'signup_IP' cannot be null

 

but it is defined by the $_POST['REMOTE_ADDR']

[Barand]

echo '<pre>', print_r($_POST, 1), '</pre>';

what does that give?

[AdamHull12]

I have fixed i just realised i declared it as post and not server

[Barand]

That was going to be my next post, but i thought I should take you through the debugging steps.

[AdamHull12]

Thanks for your help