pls help i am beginner and i am trying to create a simple Guestbook but i got error
"Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /index.php on line 43"
here is the code i use :
<?php
require ($_SERVER["DOCUMENT_ROOT"]."/komara/config/db_config.php");
$connection = @mysql_connect($db_host, $db_user, $db_password) or die ("error connecting");
mysql_select_db($db_name, $connection);
$name = $_POST["txt_name"];
$len = strlen($name);
//only write to datebase if there's a name
if ($len > 0)
{
$email = $_POST["txt_email"];
$comment = $_POST["txt_comment"];
$date = time();
$query = "INSERT INTO guest (autoID, name, email, comment, date_auto) VALUES (NULL, '$name', '$email', '$comment', '$date')";
mysql_query($query, $connection) or die(mysql_error());
}
?>
<html>
<head>
<title> Guestbook Komara </title>
</head>
<body>
<center>
<form action="<?php echo $_SERVER[PHPH_SELF]; ?>" method="POST">
<font face="arial" size="1">
Name: <input type="text" name="txt_name" >
Email: <input type="text" name="txt_email"><br><br>
Comment:<br>
<textarea style="width:75%" rows=10 name="txt_comment"></textarea>
<center><input type="submit" value="Submit"></center>
</font>
</form>
<br><br>
<table bgcolor="AAAAAA" border="0" width="75%" cellspacing=1"1" cellpading="2">
<?php
$query = "SELECT * FORM guest ORDER BY date_auto";
$result = mysql_query($query, $connection);
for ($i = 0; $i < mysql_num_rows($result); $i++) [COLOR="red"][B]// here is line 43[/B][/COLOR]
{
$name = mysql_result($result, $i, "name");
$email = mysql_result($result, $i, "email");
$email_len = strlen($email);
$comment = mysql_result($result, $i, "comment");
$date = mysql_result($result, $i, "date_auto");
$show_date = date("H:i:s m/d/Y", $date);
echo '
<tr>
<td width="50%" bgcolor="#EEEEEE">
<font face="arial" size="2">';
if ($email_len > 0)
{
echo '<b>Name:</b> <a href="mailto:'.$email.'>"'.$name.'</a>';
}
else
{
echo '<b>Name:</b> '.$name;
}
echo '
<br>
<b>Comment:</b> '.$comment.'
</font>
<td>
<td width="1%" valign="top" nowrap bgcolor="#EEEEEE">
<font face="arial" size="2">
<b>Date:</b> '.$show_date.'
</font>
</td>
</tr>
';
}
?>
</table>
<center>
</body>
</html>
