Hej jag har här en gästbok som min kusin har gjort till mig men jag får hela tiden fel... jag har skapat tabellen med tillhörande fält och jag hänvisar till den men jag får hela tiden fel...
Här är koden...
<html>
<head>
<title>Guestbook</title>
</head>
<?
if (!$db)
$db = mysql_connect("localhost","USERNAME","PASSWORD");
$seldb = mysql_select_db("guestbook");
if ( !( $seldb ))
{
echo "Warning ... error when selecting DB!<br>";
}
$guestbook_kunder_id = 1;
if ($submit != '')
{
$sql = "insert into guestbook_v2 (guestbook_when, guestbook_where,
guestbook_who, guestbook_text, guestbook_kunder_id) values
('$guestbook_when', '$guestbook_where', '$guestbook_who', '$guestbook_text',
$guestbook_kunder_id);";
mysql_query ($sql);
}
?>
<body bgcolor=#003468 text=#FFFFFF link=#FFFFFF vlink=#FFFFFF alink=#FFFFFF>
<form method=post action=guestbook.php>
<table border=0>
<tr>
<td colspan=2></td>
</tr>
<tr>
<td>Date: </td><td class=gb_text><input type=text
name=guestbook_when></td>
</tr>
<tr>
<td>Name: </td><td class=gb_text><input type=text
name=guestbook_who></td>
</tr>
<tr>
<td>Location:</td><td class=gb_text><input type=text
name=guestbook_where></td>
</tr>
<tr>
<td colspan=2><textarea name=guestbook_text rows=5
cols=40></textarea></td>
</tr>
<tr>
<td colspan=2><input type=submit value=" Send "
name="submit"><input type=reset value=" Clear "><br><br><br><hr></td>
</tr>
</table>
<?
$sql = "select * from guestbook_v2 where
guestbook_kunder_id=$guestbook_kunder_id order by guestbook_id desc;";
$res = mysql_query ($sql);
for ($i = 0; $i < mysql_num_rows($res); $i++)
{
$row = mysql_fetch_row ( $res ) ;
echo "<b>Date: </b> ".$row[1]."<br>";
echo "<b>Name: </b> ".$row[2]."<br>";
echo "<b>Location: </b> ".$row[3]."<br>";
echo $row[4]."<br><br>";
}
mysql_close ($db);
?>
</form>
</body>
</html>
Dessa fel får jag...
Warning ... error when selecting DB!
och
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/home/muaddib.nu/htdocs/test/guestbook.php on line 65
och jag har gått igenom koden själv även om jag är nybörjare men jag kan inte hitta något fel...