echo $aendern;
ausgabe?
ausgabe?
UPDATE users SET UserName = 'torti', UserPass = 'a23326fca3f081141cd031e433d3056b', UserMail = 'torsten.gadegast@kev-hannover-indians.de', name = 'Ingo Mattern', userlevel = '3' WHERE UserID = '7' AND UserPass = 'c838269ae50cdede977e1abb5965179e
$sql="UPDATE users
SET userpass=MD5('".$userpassneu."')
WHERE userid=".$_POST['UserId']." AND userpass=MD5('".$userpassalt."')";
echo $sql;
mysql_query($sql) or die(mysql_error());
UPDATE users SET UserName = 'torti', UserPass = 'a23326fca3f081141cd031e433d3056b', UserMail = 'torsten.gadegast@kev-hannover-indians.de', name = 'Ingo Mattern', userlevel = '3' WHERE UserID = '7' AND UserPass = 'c838269ae50cdede977e1abb5965179e
UPDATE users SET UserName = 'torti', UserPass = 'a23326fca3f081141cd031e433d3056b', UserMail = 'torsten.gadegast@kev-hannover-indians.de', name = 'Ingo Mattern', userlevel = '3' WHERE UserID = '7' AND UserPass = 'c838269ae50cdede977e1abb5965179e'
<?
$sql="UPDATE users
SET userpass=MD5('".$userpassneu."')
WHERE userid=".$_POST['UserId']." AND userpass=MD5('".$userpassalt."')";
echo $sql;
mysql_query($sql) or die(mysql_error());?>
<table width="60%" border="0" cellspacing="0" cellpadding="0" class="haupt">
<tr>
<td><div align="left"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><em>Update:</em></font></strong></div></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Ihr Eintrag wurde wie
folgt geändert:</font></td>
</tr>
<tr>
<td><div align="left"></div></td>
<td> </td>
</tr>
<tr>
<td><div align="left"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Username:</font></strong></div></td>
<td><? echo $UserName ?></td>
</tr>
<tr>
<td><div align="left"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Userpasswort:</font></strong></div></td>
<td></td>
</tr>
<tr>
<td><div align="left"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">E-Mail:</font></strong></div></td>
<td><? echo $UserMail ?></td>
</tr>
<tr>
<td><div align="left"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Vor-Nachname:</font></strong></div></td>
<td><? echo $name ?></td>
</tr>
<tr>
<td><div align="left"><strong><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Userlevel:</font></strong></div></td>
<td><?if($userlevel=="1"){echo "Admin";}
if($userlevel=="2"){echo "Co-Admin";}
if($userlevel=="3"){echo "Mitarbeiter";};?></td>
</tr>
</table>
UPDATE users SET userpass=MD5('xxxx') WHERE userid= AND userpass=MD5('xxxxxx')You have an error in your SQL syntax near 'AND userpass=MD5('xxxxxx')' at line 3
<?
$sql="UPDATE users
SET userpass=MD5('".$userpassneu."')
username=('".$username."')
userlevel=('".$userlevel."')
usermail=('".$usermail."')
name=('".$name."')
WHERE userid=".$_POST['UserID']." AND userpass=MD5('".$userpassalt."')";
echo $sql;
mysql_query($sql) or die(mysql_error());?>
Kommentar