Fejl i koden
Jeg er ved at lave en database hvor man skal kunne se hvem der har lejet hvilket stykke kunst og hvornår det skal afleveres.Min kode ser sådan her ud.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Elevliste</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="DAP/CSS/Kunstforeningen.css" rel="stylesheet" type="text/css">
</head>
<body>
<?
$db =mysql_connect("localhost","root","");
mysql_select_db("kunstner", $db);
if($_POST["skriv"]){
$kunstner=$_POST["kunstner"];
$type=$_POST["type"];
$lejer=$_POST["lejer"];
$aflevering=$_POST["aflevering"];
if(!get_magic_quotes_gpc()){
$kunstner=addslashes($kunstner);
$type=addslashes($type);
$leje=addslashes($lejer);
$aflevering=addslashes($aflevering);
}
mysql_query("INSERT INTO kunstner(kunstner, type, lejer, aflevering) VALUES ('$kunstner','$type','$lejer', '$aflevering')");
}
?>
<form ACTION= "<? echo $PHP_SELF; ?>" method= "POST" class="style1">
<div align="justify">
<p> </p>
</div>
<td><p align="justify" class="style57">
<input type ="hidden" name="skriv" value="1">
</p> </td>
<td><div align="justify">
<p>
<span class="style57">Kunstner:</span>
<input name="type" type="text" size="30">
<span class="style57">Type:</span> <input name="lejer" type="text" size="30">
<span class="style57">Lejer: </span> <input name="kunstner" type="text" size="30">
</p>
<p><span class="style57">Aflevering:</span>
<input name="aflevering" type="text" size="30">
</p>
<p> </p>
</div></td>
</tr>
<tr>
<div align="center"><p>
<input name="submit" type= submit class="style1" value ="send">
</p>
<p><br>
<span class="style54"></span> </p>
</div>
</form>
<table width="291" border="0" align="right">
<tr> </tr>
</table>
<span class="style58"><br>
<br>
</span>
<table>
<?
$foresp= mysql_query("SELECT kunstner, type, lejer, aflevering FROM kunstner ORDER BY kunstner ASC");
while($data = mysql_fetch_array($foresp))
{
echo "<tr> <td valign=\"top\">";
echo $data["kunstner"];
echo " ";
echo $data["type"];
echo " ";
echo "<br>";
echo $data["lejer"];
echo " ";
echo $data["aflevering"];
echo " ";
echo "</td><td valign=\"top\">";
echo "</td> </tr>";
}
?>
</table>
</body>
</html>
Den giver mig denne fejl.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp2\htdocs\testdatabase.php on line 65
Er der nogle der ville kunne hjælpe mig med at oprette denne database??