Insert Into

Beste,

Waarom werkt het volgend script niet? En ja, ik heb een connectie gemaakt.

mysql_query("INSERT INTO ".$table_prefix."appoint (salution, first_name, last_name. tussenv, birth, email, telnr, date, time, tally, version, state)
VALUES (".$_POST[salution].", ".$_POST[first_name].", ".$_POST[tussenv].", ".$_POST[birth_year]."-".$_POST[birth_month]."-".$_POST[birth_day].", ".$_POST[email].", ".$_POST[telnr].", ".$_POST[year]."-".$_POST[month]."-".$_POST[day].", ".$_POST[time].", ".$_POST[tally].", ".$_POST[version].", ".$_POST[state].")");

Even dit ervan maken en de fout dumpen:

mysql_query("INSERT INTO ".$table_prefix."appoint (salution, first_name, last_name. tussenv, birth, email, telnr, date, time, tally, version, state)
VALUES (".$_POST[salution].", ".$_POST[first_name].", ".$_POST[tussenv].", ".$_POST[birth_year]."-".$_POST[birth_month]."-".$_POST[birth_day].", ".$_POST[email].", ".$_POST[telnr].", ".$_POST[year]."-".$_POST[month]."-".$_POST[day].", ".$_POST[time].", ".$_POST[tally].", ".$_POST[version].", ".$_POST[state].")") or die(mysql_error());

Nog een fout. Wat betekend het? En dan nog wat. Mijn database:

Column count doesnt match value count at row 1

mysql_query("
INSERT INTO ".$table_prefix."appoint
(
    salution,
    first_name,
    last_name,
    tussenv,
    birth,
    email,
    telnr,
    date,
    time,
    tally,
    version,
    state
)
VALUES (
    ".$_POST[salution].",
    ".$_POST[first_name].",
    ".$_POST[last_name].",
    ".$_POST[tussenv].",
    ".$_POST[birth_year]."-".$_POST[birth_month]."-".$_POST[birth_day].",
    ".$_POST[email].",
    ".$_POST[telnr].",
    ".$_POST[year]."-".$_POST[month]."-".$_POST[day].",
    ".$_POST[time].",
    ".$_POST[tally].",
    ".$_POST[version].",
    ".$_POST[state]."
)") or die(mysql_error());

Werkt het zo wel?

Uhhh, ja. Als we jou niet hadden