mysql_fetch_row fejl!
Hvad er fejlen i dettte script:<HTML>
<HEAD><TITLE>Brugersystem</TITLE></HEAD>
<BODY>
<?
$db = mysql_connect("localhost", "xxx", "xxx");
mysql_select_db("brugersys", $db);
if($skriv){
mysql_query("INSERT INTO brugersys (nick, navn, adresse, postnr, by, email) VALUES ('$nick', '$navn', '$adresse', '$postnr', '$by', '$email')");
}
?>
<div align="left">
<FORM METHOD=POST ACTION=<? echo $PHP_SELF; ?>>
<INPUT TYPE=hidden NAME=skriv VALUE=1>
nick: <INPUT TYPE=text NAME=nick><BR>
navn: <INPUT TYPE=text NAME=navn><BR>
adresse: <INPUT TYPE=text NAME=adresse><BR>
postnr: <INPUT TYPE=text NAME=postnr><BR>
adresse: <INPUT TYPE=text NAME=adresse><BR>
by: <INPUT TYPE=text NAME=by><BR>
email: <INPUT TYPE=text NAME=email>
<INPUT TYPE=submit VALUE="send">
</FORM>
<BR><BR>
<TABLE align="center">
<TR><TD>
<?
$foresp = mysql_query("SELECT nick, navn, adresse, postnr, by, email FROM brugersys ORDER BY brugernummer DESC");
while($data = mysql_fetch_row($foresp)){
echo "nick: $data[0]";
echo "navn: $data[1]";
echo "adresse: $data[2]";
echo "postnr: $data[3]";
echo "by: $data[4]";
echo "email: $data[5]";
}
?>
</TD></TR>
</TABLE>
</div>
</BODY>
</HTML>
- scriptet kan findes her: http://www.get-ready.dk/brugersys.php
