Hmm.. virker stadig ikke.. datoen bliver ikke opdateret.. Du kan se hele koden i sammenghæng.. ved ikke om det hjælper;)
<?php
require_once("../members/common.php");
$Id = $_GET[id];
$test = "";
if($_GET["loebetidForAnnonce"] != 15 || $_GET["loebetidForAnnonce"] != 30 || $_GET["loebetidForAnnonce"] != 45)
{
$test.= "";
} else {
$test.= "loebetidForAnnonce = DATE_ADD(NOW(), INTERVAL " . $loebetidForAnnonce . " DAY),";
}
// update database
if( isset( $_REQUEST[produkt], $_REQUEST[supplerendeTekst], $_REQUEST[pris], $_REQUEST[loebetidForAnnonce], $_REQUEST[tlf1], $_REQUEST[tlf2], $_REQUEST[email]) )
{
$SQL = "UPDATE salgAfProdukt SET produkt = '$produkt', supplerendeTekst = '$supplerendeTekst', pris = '$pris', $test tlf1 = '$tlf1', tlf2 = '$tlf2', email = '$email' WHERE id = '$Id'";
mysql_query($SQL);
echo "<b><span class=\"speciel\">Annoncen er opdateret!</span>";
}
$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=\"../members/mineSalgsannoncer.php\"><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]' maxlength=\"33\"></span><br>
<span class=\"lille\"> <textarea name=\"supplerendeTekst\" wrap=\"physical\" cols=\"34\" rows=\"4\" onKeyDown=\"textCounter(this.form.supplerendeTekst,this.form.remLen,350);\" onKeyUp=\"textCounter(this.form.supplerendeTekst,this.form.remLen,350);\">".$raekke['supplerendeTekst']."</textarea></span></td>
<br>
<input readonly type=\"hidden\" name=\"remLen\" size=\"3\" maxlength=\"3\" value=\"350\">
</tr>
</table>
<table width=356 border=\"0\" cellspacing=\"5\" cellpadding=\"0\"bgcolor=\"#FFFFFF\">
<tr>
<td width=95 valign=\"top\"><span class=\"mellem\"></span></td>
<td width=261 valign=\"top\"><span class=\"lilleS\"><input type='hidden' name='id' value='$raekke[Id]'></span></td>
</tr>
<tr>
<td width=95 valign=\"top\"><span class=\"mellem\">Pris:</span></td>
<td width=261 valign=\"top\"><span class=\"lilleS\"><input type='text' name='pris' value='$raekke[pris]' maxlength=\"5\"> Kr.<br><br></span></td>
</tr>
<tr>
<td width=95 valign=\"top\"><span class=\"mellem\">Tlf 1:</span></td>
<td width=261 valign=\"top\"><span class=\"lilleS\"><input type='text' name='tlf1' value='$raekke[tlf1]' maxlength=\"8\"></span></td>
</tr>
<tr>
<td width=95 valign=\"top\"><span class=\"mellem\">Tlf 2:</span></td>
<td width=261 valign=\"top\"><span class=\"lilleS\"><input type='text' name='tlf2' value='$raekke[tlf2]' maxlength=\"8\"></span></td>
</tr>
<tr>
<td width=95 valign=\"top\"><span class=\"mellem\">E-mail:</span></td>
<td width=261 valign=\"top\"><span class=\"lilleS\"><input type='text' name='email' value='$raekke[email]' maxlength=\"40\"></span></td>
</tr>
<tr>
<td width=95 valign=\"top\"><span class=\"mellem\">By:</span></td>
<td width=261 valign=\"top\"><span class=\"lilleS\"><input type='text' name='bynavn' value='$raekke[bynavn]' readonly></span></td>
</tr>
<tr>
<td width=95><span class=\"lille\">Ny løbetid:</span></td>
<td width=261><span class=\"lille\">15 dage</span><input type='radio' name='loebetidForAnnonce' value='15' border='0'> <span class=\"lille\"> | 30 dage</span><input type='radio' name='loebetidForAnnonce' value='30' border='0'> <span class=\"lille\"> | 45 dage</span><input type='radio' name='loebetidForAnnonce' value='45' border='0'></td>
</tr>
</table>
<input type=\"submit\" value=\"opdatér\" name=\"update\"></form>
<form action=\"sletDinSalgsannonce.php\" method=\"get\" name=\"FormName\">
<input type=\"hidden\" name=\"Id\" value=\"$Id\">
<input type=\"submit\" name=\"submitButtonName\" value=\"Slet annoncen\" border=\"0\">
</form>
<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>
";
?>
