Svenja: Warum geht das nicht?

Beitrag lesen

Hallo,

ich habe ein Script um Daten in die DB zu schicken. Hmm aber nun bekomme ich nur folgende Meldung:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alter, geschlecht, stadt, mail, nummer, ' at line 5

Hmm was mache ich da nur falsch? Hier mal das ganze Script:

<?php
require_once 'config/cfg.inc.php';

if(!empty($_POST))
{
    $Pfade_in_DB = array();
    foreach ($_FILES as $Artikelbild => $File)
    {
        if ($File['error'] == 0)
        {
            $TempName   = pathinfo($File['tmp_name']);
            $RealName   = pathinfo($File['name']);

$FileName   = $TempName['basename'].'.'.$RealName['extension'];

$Pfade_in_DB[$Artikelbild] = '/img/passbilder/'.$FileName;

move_uploaded_file(
                $File['tmp_name'],
                $_SERVER['DOCUMENT_ROOT'] . '/' .$Pfade_in_DB[$Artikelbild]
            );
            chmod($_SERVER['DOCUMENT_ROOT'] . '/' .$Pfade_in_DB[$Artikelbild] , 0777);
        }
    }
        $sql = "INSERT INTO reg_user
                (
                    name,
                    vorname,
                    geb,
                    geschlecht,
     stadt,
     mail,
     nummer,
     passbild,
     t-shirt,
     username,
     passwort,
     passwort_wdh,
                    ip,
     datum
                )
                VALUES
                (
                    '" . mysql_real_escape_string($_POST["name"]) . "',
                    '" . mysql_real_escape_string($_POST["vorname"]) . "',
                    '" . mysql_real_escape_string($_POST["geb"]) . "',
                    '" . mysql_real_escape_string($_POST["geschlecht"]) . "',
                    '" . mysql_real_escape_string($_POST["stadt"]) . "',
                    '" . mysql_real_escape_string($_POST["mail"]) . "',
                    '" . mysql_real_escape_string($_POST["nummer"]) . "',
                    '" . $Pfade_in_DB['passbild'] . "',
                    '" . mysql_real_escape_string($_POST["t-shirt"]) . "',
                    '" . mysql_real_escape_string($_POST["username"]) . "',
                    '" . mysql_real_escape_string($_POST["passwort"]) . "',
                    '" . mysql_real_escape_string($_POST["passwort_wdh"]) . "',
                    '" . ip2long($_SERVER["REMOTE_ADDR"]). "',
     NOW()

)
                ";
        mysql_query($sql) OR die(mysql_error());

header("Location: reg_danke.php");
exit;
}
?>