Opdaterer ved at slette værdierne i annoncen
Jeg har nedenstående hvor man skal kunne rette i en annonce. Mit problem er at den i stedet for at huske rettelserne bare sletter alt.. nogen som kan hjælpe?<?php
require_once("../members/common.php");
$Id = $_GET[id];
$hent = mysql_query("SELECT * FROM salgAfProdukt left join postnr on salgAfProdukt.postNr = postnr.postnr WHERE id = '$Id'") or die(mysql_error());
$raekke = mysql_fetch_assoc($hent);
echo "<div align=\"center\"><table width=\"auto\" border=\"0\" cellspacing=\"\" cellpadding=\"0\" bgcolor=\"#FFFFFF\"><tr><td width=\"75\" valign=\"top\"><span class=\"mellem\"> ";
echo "<a href=\"java script:history.go(-1)\"><div align=\"center\"><font color=\"#0000cd\">< Tilbage</font></div></a><br>";
echo "</span></td></tr></table></div>";
echo "
<table width=\"560\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\" bgcolor=\"#FFFFFF\">
<tr>
<td width=\"490\" valign=\"top\"><span class=\"mellem\"><input type='text' name='produkt' value='$raekke[produkt]'></span> <br><span class=\"lille\"><textarea name='supplerendeTekst' rows='6' cols='50'>".$raekke['supplerendeTekst']." </textarea></span></td>
</tr></table>
<table width=\"490\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\"bgcolor=\"#FFFFFF\">
<tr>
<td width=\"55\" valign=\"top\"><span class=\"mellem\">Pris:</span></td>
<td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='pris' value='$raekke[pris]'> Kr.<br><br></span></td>
</tr>
<tr>
<td width=\"55\" valign=\"top\"><span class=\"mellem\">Tlf 1:</span></td>
<td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='tlf1' value='$raekke[tlf1]'></span></td>
</tr>
<tr>
<td width=\"55\" valign=\"top\"><span class=\"mellem\">Tlf 2:</span></td>
<td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='tlf2' value='$raekke[tlf2]'></span></td>
</tr>
<tr>
<td width=\"55\" valign=\"top\"><span class=\"mellem\">E-mail:</span></td>
<td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='email' value='$raekke[email]'></span></td>
</tr>
<tr>
<td width=\"55\" valign=\"top\"><span class=\"mellem\">By:</span></td>
<td width=\"300\" valign=\"top\"><span class=\"lilleS\"><input type='text' name='bynavn' value='$raekke[bynavn]' readonly></span></td>
</tr>
</table>
<tr>
<td colspan=\"2\">";
require_once("../members/common.php");
$imgID = mysql_real_escape_string($_GET['id']);
$imgquery = mysql_query("SELECT * FROM billeder_salgAfProdukt WHERE artikelid = '".$imgID."' LIMIT 5") or die(mysql_error());
while($imgrow = mysql_fetch_assoc($imgquery))
{
echo "<div align=\"center\"><img src=\"imageSalgsannoncer.php?id=".$imgrow[id]."\"></div><br><br>";
}
echo " </td>
</tr>
";
?>
<body>
<form action="redigerDineSalgsannoncer.php" method="post" name="FormName">
<?php
require_once("../members/common.php");
$Id = $_GET[id];
$produkt==$produkt;
$supplerendeTekst==$supplerendeTekst;
$pris==$pris;
$tlf1==$tlf1;
$tlf2==$tlf2;
$email==$email;
mysql_query("update salgAfProdukt set produkt = '$produkt', supplerendeTekst = '$supplerendeTekst', pris = '$pris', tlf1 = '$tlf1', tlf2 = '$tlf2', email = '$email' WHERE Id = '$Id'");
echo 'Annoncen er opdateret!';
?>
<input type="submit" name="submitButtonName" border="0">
</form>
<p></p>
</body>
