problemer med mysql_fetch_array
jeg får følgende fejlmeddelse:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /customers/andreasbrun.dk/andreasbrun.dk/httpd.www/have/to-do/index.php on line 35
når jeg kører denne:
<html>
<title> To Do Liste</title>
<?
require ("pass.php");
?>
<?
print ("<font size=\"4\"><center><b>To Do Liste</b></font></center><br><br>");
?>
<div align="center"><br>
<table><tr><td align="center">
<form name="aftale" method="post" action="index.php?tilfoej=1"></b>
<tr><td>Aftale</td><td> <input type="text" name="aftale" value=""></td></tr>
Priv
<select name="priv">
<option value="1">Høj</option>
<option value="2">Lav</option>
</select>
<tr><td><input type="submit" value="tilføj"></td></tr>
</td></tr></table></div>
<?
if ($tilfoej == "1") {
$dato_nu = date("d/m/Y");
$tid = time();
$tiden_nu = date("G:i", $tid);
mysql_select_db("todo",$conn);
$mysql_query = "INSERT INTO todo(todo, priv, dato, tid) values ('$aftale', '$priv', '$dato_nu', '$tiden_nu')";
mysql_query("$mysql_query");
print ("<meta http-equiv=\"refresh\" content=\"0; url=$PHP_SELF\">");
}
else {
mysql_select_db("todo");
$sql ="select * from todo order by priv,tid,dato";
$result = mysql_query($sql);
while($post=mysql_fetch_array($result)) {
if ($post[priv] == "1") {
$post[priv] = ("red");
}
if ($post[priv] == "2") {
$post[priv] = ("blue");
}
if ($post[loest] == "1") {
$post[loest] = ("<strike>");
}
echo "<br><table align=\"center\" width=\"300\"><tr><td align=\"center\" bgcolor=\"#CECECE\"><font face=\"arial\" size=\"2\">$post[dato] $post[tid] <a href=\"$PHP_SELF?loest=1&id=$post[id]\">Løst</a> <a href=\"$PHP_SELF?slet=1&id=$post[id]\">Slet</a></td></tr>
<tr><td align=\"left\" width=\"300\"><font face=\"arial\" size=\"2\" color=\"$post[priv]\">$post[loest]$post[todo]</strike></td></tr></tr></table>";
}
}
print ("<br></table>");
?>
<?
if ($loest == "1") {
mysql_select_db("todo",$conn);
$mysql_query = "UPDATE liste SET loest='1' where id='$id'";
mysql_query("$mysql_query");
print ("<meta http-equiv=\"refresh\" content=\"0; url=$PHP_SELF\">");
}
if ($slet == "1") {
mysql_select_db("todo",$conn);
$mysql_query = "DELETE FROM liste where id='$id'";
mysql_query("$mysql_query");
print ("<meta http-equiv=\"refresh\" content=\"0; url=$PHP_SELF\">");
}
?>
</html>
Er der nogen kloge hoveder derude der kan hjælpe med at rette fejlen?
