Hi Leute,
Ich versuche gerade ein login script zu schreiben,jedoch bekommen diese Error message :
Insertion Failed:Column count doesn't match value count at row 1
Dies ist mein Code:
Ich versuche gerade ein login script zu schreiben,jedoch bekommen diese Error message :
Insertion Failed:Column count doesn't match value count at row 1
Dies ist mein Code:
Code:
<?php
include 'dbc.php';
$errors =array();
if (isset($_POST['doRegister']))
{
$user_ip = $_SERVER['REMOTE_ADDR'];
$pwd = md5($_POST['pwd']);
// Generates activation code simple 4 digit number
$activ_code = rand(1000,9999);
$fullname = $_POST['full_name'];
$usr_email = $_POST['usr_email'];
$user_name = $_POST['user_name'];
$user_postcode = $_POST['user_postcode'];
$sql_insert = "INSERT into `users`
(`full_name`,`user_email`,`pwd`,`postcode`,`activation_code`,`user_name`
)
VALUES
('$fullname','$usr_email','$pwd','$user_postcode',now(),'$user_ip','$activ_code','$user_name'
)
";
mysql_query($sql_insert,$link) or die("Insertion Failed:" . mysql_error());
$user_id = mysql_insert_id($link);
$md5_id = md5($user_id);
}
?>
Zuletzt bearbeitet: