Problem med updatescript
Hvad gør at denne kode:<!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>
<?
if($ret == ja){
$id = $_GET['ID'];
include("sql-connect.php");
if($kodeord){
$markedet = mysql_query("SELECT ID, kodeord from marked WHERE ID = $id");
while($marked = mysql_fetch_array($markedet)){
$indtastet = $marked['kodeord'];
if($kodeord == $indtastet){
mysql_close();
mysql_query("UPDATE marked SET ting='$ting', beskrivelse='$beskrivelse', pris='$pris', email='$email', tlf='$tlf' WHERE ID = $id");
echo "Din annonce er nu opdateret!<br><a href=\"index.php\">Tilbage til \"Skimarked\"<a/>";
}
elseif($kodeord == "skibilig")
{
$id = $_GET['ID'];
mysql_query("UPDATE marked SET ting='$ting', beskrivelse='$beskrivelse', pris='$pris', email='$email', tlf='$tlf' WHERE ID = $id");
echo "Annoncen 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'];
include("sql-connect.php");
$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 ID DESC LIMIT 5");
while($marked = mysql_fetch_array($markedet)){
?>
<form action="<? echo $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>
Kommer med denne fejl:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /STORE/skibilligt_dk/public_html/test/kobsalg/ret.php on line 16
Håber på hurtige svar:D
