Datenbankerror

23.11.2004, 19:55

Hallo ich bekomme folgenden Fehler!:

Code:

You have an error in your SQL syntax near 'alter,logo, bild) values ('RaptorCry','*****',cda29055454099353' at line 1

Hier der Code:

Code:

<?php
if ($action=="proceed")
{

include ("mysql.php");

 if ("$_REQUEST[rang]==Administrator")
 {
 $rang="2";
 }
 else
 {
 $rang="1";
 }

 $pwd=md5($_REQUEST[pw]);

 $reg =mysql_query("INSERT INTO **** (user,mail,pw,rang,msn,icq,vorname,nachname,alter,logo, bild)
      values ('$_REQUEST[user]','$_REQUEST[mail]',$pwd,$rang,'$_REQUEST[msn]','$_REQUEST[icq]','$_REQUEST[vorname]','$_REQUEST[nachname]','$_REQUEST[alter]','$_REQUEST[logo]','$_REQUEST[bild]')")
      or die (mysql_error());

}

else
{
$titel="Registrierung >> Daten eingeben";
?>

<html>
<body>
<form method="POST" action="register.php?action=proceed">
  <div align="center">
    <center>
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber2" width="250" height="228">
      <tr>
        <td height="7" colspan="2">Member hinzufügen</td>
      </tr>
      <tr>
        <td height="6"></td>
        <td height="6"></td>
      </tr>
      <tr>
        <td height="6">Gamertag:</td>
        <td height="6">
        <input type="text" name="user" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Email:</td>
        <td height="19">
        <input type="text" name="mail" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Msn:</td>
        <td height="19">
        <input type="text" name="msn" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Icq:</td>
        <td height="19">
        <input type="text" name="icq" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Vorname:</td>
        <td height="19">
        <input type="text" name="vorname" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Nachname:</td>
        <td height="19">
        <input type="text" name="nachname" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Alter:</td>
        <td height="19">
        <input type="text" name="alter" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Logo:</td>
        <td height="19">
        <input type="text" value="http://" name="logo" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19">Bild:</td>
        <td height="19">
        <input type="text" value="http://" name="bild" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="19"></td>
        <td height="19"></td>
      </tr>
      <tr>
        <td height="19">Passwort:</td>
        <td height="19">
        <input type="password" name="pw" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="7">Passwort:</td>
        <td height="7">
        <input type="password" name="pw2" size="20" style="font-family: Verdana; font-size: 10pt; border: 1px solid #000000; background-color: #FF0000"></td>
      </tr>
      <tr>
        <td height="3"></td>
        <td height="3"></td>
      </tr>
      <tr>
        <td height="2">Typ</td>
        <td height="2">
        <select size="1" name="typ" style="border: 1px solid #000000; background-color: #FF0000">
        <option selected>Moderator</option>
        <option>Administrator</option>
        </select></td>
      </tr>
      <tr>
        <td height="1"></td>
        <td height="1"></td>
      </tr>
      <tr>
        <td height="6"></td>
        <td height="6">
        <input type="submit" value="Registrieren" name="B1" style="color: #FFFFFF; border: 1px solid #000000; background-color: #0000FF"></td>
      </tr>
    </table>
    </center>
  </div>
</form>


</p>
</body>

</html>
<?php
}
?>

Sorry wegen dem vielen HTML scheiss
Was ist falsch?