php fejl med colum
Hej.jeg får denne fejl:
Column count doesn't match value count at row 1
Fatter den ikke lige men her er koden hvor fejlen opstår i:
$stmt = sprintf( "INSERT INTO {$config["prefix"]}_users( name, password, realname, email, question1,"
." question2, url, receivenews, receiverel, country, city, state, icq, Msn, sex, Clan, CPU, Monitor, Grafikkort, Hoeretelefoner, Mus, Musemaatte, Forbindelse, Operativsystem, Oploesning, Sensitivity, comments, session,"
." active, dateregistered )"
." VALUES ('%s', '%s', '%s', '%s', '%s', '%s' '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s',"
." '%s', '%s', '%s', NOW() )",
addslashes($userform->fields["name"]->value),
md5($userform->fields["passwd1"]->value),
addslashes($userform->fields["realname"]->value),
addslashes($userform->fields["email"]->value),
addslashes($userform->fields["question1"]->value),
addslashes($userform->fields["question2"]->value),
addslashes($userform->fields["url"]->value),
addslashes($userform->fields["receivenews"]->value),
addslashes($userform->fields["receiverel"]->value),
addslashes($userform->fields["country"]->value),
addslashes($userform->fields["city"]->value),
addslashes($userform->fields["state"]->value),
addslashes($userform->fields["icq"]->value),
addslashes($userform->fields["Msn"]->value),
addslashes($userform->fields["sex"]->value),
addslashes($userform->fields["Clan"]->value),
addslashes($userform->fields["CPU"]->value),
addslashes($userform->fields["Monitor"]->value),
addslashes($userform->fields["Grafikkort"]->value),
addslashes($userform->fields["Hoeretelefoner"]->value),
addslashes($userform->fields["Mus"]->value),
addslashes($userform->fields["Musemaatte"]->value),
addslashes($userform->fields["Forbindelse"]->value),
addslashes($userform->fields["Operativsystem"]->value),
addslashes($userform->fields["Oploesning"]->value),
addslashes($userform->fields["Sensitivity"]->value),
addslashes($userform->fields["comments"]->value),
$user_session,
$active
);
$ret = db_query($stmt) or die(db_error());
Håber i kan hjælpe det haster lidt ;)
