Rettet noget mere til:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta name="Generator" content="Stone's WebWriter 4">
<meta name="Author" content="Steen Hjelmstrand" />
<link rel="stylesheet" type="text/css" href="../selskaber/style.css">
</head>
<body>
<font size="4">Rodeskuffen - Opdater Annonce</font>
<?
include("sql-connect.php");
if(isset($_POST['ret']) && $_POST['ret'] == 'ja'){
$id = $_GET['ID'];
$ting = $_POST['ting'];
$beskrivelse = $_POST['beskrivelse'];
$pris = $_POST['pris'];
$email = $_POST['email'];
$tlf = $_POST['tlf'];
$kodeord = $_POST['kodeord'];
if($kodeord != ''){
$query = "SELECT ID, kodeord from marked WHERE ID = $id";
$res = mysql_query($query) or die(mysql_error());
while($kode = mysql_fetch_array($res)){
$indtastet = $kode['kodeord'];
if($kodeord == $indtastet || $kodeord == "skibiligadmin"){
mysql_query("UPDATE marked SET ting='$ting', beskrivelse='$beskrivelse', pris='$pris', email='$email', tlf='$tlf' WHERE ID = '$id'") or die(mysql_error());
echo "Din annonce er nu opdateret!<br><a href=\"index.php\">Tilbage til \"Skimarked\"<a/>";
} else {
$forside = "/test/kobsalg/";
header("Location:
http://" . $_SERVER['HTTP_HOST'] . $forside);
}
}
}
} else {
$id = $_GET['ID'];
$markedet = mysql_query("SELECT marked.ID, emne, ting, beskrivelse, pris, email, tlf, kodeord, dato, markedsemneID FROM marked INNER JOIN markedsemner ON marked.markedsemneID = markedsemner.ID WHERE marked.ID = '$id' ORDER BY marked.ID DESC LIMIT 5") or die(mysql_error());
while($marked = mysql_fetch_assoc($markedet)){
?>
<form action="<? echo $_SERVER['PHP_SELF']?>" method="post">
<table border="0">
<tr>
<td>Ting:</td>
<td><input type="text" value="<? echo $marked['ting']?>" name="ting"></td>
</tr>
<tr>
<td>Beskrivelse:</td>
<td><textarea wrap="off" name="beskrivelse" cols="20" rows="7"><? echo $marked['beskrivelse']?></textarea></td>
</tr>
<tr>
<td>Pris:</td>
<td><input type="text" value="<? echo $marked['pris']?>" name="pris"></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="text" value="<? echo $marked['email']?>" name="email"></td>
</tr>
<tr>
<td>Telefon:</td>
<td><input type="text" value="<? echo $marked['tlf']?>" name="tlf"></td>
</tr>
<tr>
<td>Det indtastede kodeord:</td><td><input type="password" name="kodeord"></td></tr>
<tr>
<td colspan="2"><input type="submit" value="Opdater"></td>
</tr>
</table>
<input type="hidden" name="ret" value="ja">
</form>
<?
}
}
?>
</body>
</html>
Ny bruger
Nybegynder
Opret
Preview
