opdatere en post i mysql
hejsa et lille simpelt spmjeg har prøvet at lave dette her script som skal opdatere en email i en db er der nogen af jer der kan se hvad fejlen er. jeg får denne her fejl:
Unknown column 'old_email' in 'where clause'
scriptet/////
<center>
<h3>Skift E-Mail</h3>
<FORM action="opdate.php" method="POST">
<TABLE border="1">
<tr bgcolor="#ccccccc">
<td width="150">E-Mail</td>
<td width="150">Navn</td>
</tr>
<tr>
<td>Gammel E-Mail:</td>
<td align="center"><INPUT type="text" name="old_email" size="30" maxlength="30"></td>
</tr>
<tr>
<td>Ny E-Mail:</td>
<td align="center"><INPUT type="text" name="new_email" size="30" maxlength="30"<td>
</td>
<tr>
<td colspan="2" align="left"><INPUT type="submit" value="Opret dig i systemet"></td>
</tr>
</TABLE>
</form>
</CENTER>
<?PHP
$old_email = $_POST['old_email'];
$new_email = $_POST['new_email'];
include("dbconnect.php");
#$old = mysql_query("select from mailing where email like".$old_email."'") or die(mysql_error());
#mysql_query("update email set = '$_POST[new_email]' where email = '$_POST[old_email]'") or die(mysql_error());
mysql_query("UPDATE mailing SET new_email='$_POST[new_email]' WHERE old_email='$_POST[old_email]'") or die(mysql_error());
?>
hilsen krydset
