Column count doesn't match value

Column count doesn't match value count at row 1

mysql_query("insert into lz_members(username,password,email,adminid,groupid,timeoffset,customshow,posts,gender) value('$uid','$pwd','$mail','$lastip','0','10',9999,2,$post,$sex)") or die(mysql_error());

仔细检查可以发现是insert into的字段与value个数不相等所选成的.