duannai5879
duannai5879
2013-01-28 01:54

列数与第1行插入表中的值计数不匹配

  • php
  • mysql
  • sql

Ok. Ive been starting to make a forum from scratch and upon registering my browser comes up with this error: Column count doesn't match value count at row 1

$insert = mysql_query("
      INSERT INTO users (user_id, user_name, user_pass, user_email, user_date, user_level, user_posts) 
      VALUES( '', '" . mysql_real_escape_string($username) . "', '" . sha1($password) . "''" . mysql_real_escape_string($email) . "', NOW(), 0, 0)
");

Ive checked this thousands of times...and I cannot see the problem!

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

2条回答