hey another question from me.. still working on the guestbook thing, but started over with a new one, problems i dont understand came on my way..
please can you look at this and explain the mistake to me? i really dont see whats wrong.
This is the warning i receive while i test it:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:FoxServwwwtestguestbookindex.php on line 19
this is my code:
<?
$db = mysql_connect(\"lxxx\",\"xxx\",\"xxx\");
mysql_select_db (\"testgastenboek\", $db);
$sql = \'SELECT * FROM `testgastenboek`;\';
$result = mysql_query($sql,$db);
while ( $myrow = mysql_fetch_array($result) )
{
echo \"<b>Name:</b>\";echo \"<br>\";
echo $myrow[name];
echo \"<br>\";
echo \"<b> Email:</b>\";
echo \"<br>\";
echo \"<a href=\"mailto:\";
echo $myrow;
echo \"\">\";
echo $myrow;
echo \"</a>\";
echo \"<br>\";
echo \"<b> Homepage:</b>\";
echo \"<br>\";
echo \"<a href=\"\";
echo $myrow;
echo \"\">\";
echo $myrow;
echo \"</a>\";
echo \"<br>\";
echo \"<b>Comment:</b>\";
echo \"<br>\";
echo $myrow[comment];
echo \"<br>\";
echo \"<br>\";
echo \"<a href=changeform.php?id=$myrow[id]>[change]</a>\";
echo \" \";
echo \"<a href=changeform.php?id=$myrow[id]>[delete]</a>\";
echo \"<hr noshadow width=\"300\" align=\"left\" color=\"#FF6600\">\";
}
?>
i hope this is enough information..
thanks in advance, Princess