problem with connecting mySQL database

[maxinator]

hi guys,

i am a new learner of php.
i simply tried to make a guestbook.
first, i created a guestbook table(gaestebuch) in my database (a5286642_domino)

CREATE TABLE `gaestebuch` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
`comment` longtext NOT NULL,
`datetime` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

then i made a guestbook page (guestbook.php)

table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><strong>guestbook</strong></td>
</tr>
</table>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form id="form1" name="form1" method="post" action="addguestbook.php">
<td>
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="117">Name</td>
<td width="14">:</td>
<td width="357"><input name="name" type="text" id="name" size="40" /></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input name="email" type="text" id="email" size="40" /></td>
</tr>
<tr>
<td valign="top">Comment</td>
<td valign="top">:</td>
<td><textarea name="comment" cols="40" rows="3" id="comment"></textarea></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Submit" /> <input type="reset" name="Submit2" value="Reset" /></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
<table width="403" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td width="397"><strong><a href="viewguestbook.php">View Guestbook</a> </strong></td>
</tr>
</table>

then addguestbook.php

<?php
$host="localhost"; 
$username="xxxx";  

$password="xxxx"; 
$db_name="a5286642_domino"; 
$tbl_name="gaestebuch";  

mysql_connect("$host", "$username", "$password")or die("cannot connect server "); 
mysql_select_db("$db_name")or die("cannot select DB");

$datetime=date("y-m-d h:i:s"); 

$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')";
$result=mysql_query($sql);


if($result){
echo "Successful";
echo "<BR>";
echo "<a href='viewguestbook.php'>View guestbook</a>"; 
}

else {
echo "ERROR";
}

mysql_close();
?>

and viewguestbook.php

<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td><strong>view guestbook | <a href="guestbook.php">guestbook</a> </strong></td>
</tr>
</table>
<br>

<?php

$host="localhost";  

$username="xxxx";  

$password="xxxx";  

$db_name="a5286642_domino"; 
$tbl_name="gaestebuch";  

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect server "); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){
?>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td><table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td>ID</td>
<td>:</td>
<td><? echo $rows['id']; ?></td>
</tr>
<tr>
<td width="117">Name</td>
<td width="14">:</td>
<td width="357"><? echo $rows['name']; ?></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><? echo $rows['email']; ?></td>
</tr>
<tr>
<td valign="top">Comment</td>
<td valign="top">:</td>
<td><? echo $rows['comment']; ?></td>
</tr>
<tr>
<td valign="top">Date/Time </td>
<td valign="top">:</td>
<td><? echo $rows['datetime']; ?></td>
</tr>
</table></td>
</tr>
</table>
<BR>
<?
}
mysql_close();
?>

but, when i tried use it a problem occures. and i really dont know why.
could someone help me solving this?

thanks..

[bradgrafelman]

What's the problem? Do you have error_reporting set to E_ALL and display_errors (or log_errors, as appropriate) set to On? If so, are you getting any PHP errors? (Hint: You should be.)

One problem I note is here:

$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')"; 

$name, $email, and $comment are all undefined variables. Perhaps you meant to refer to the POST'ed data (e.g. the $_POST array)?

[systm]

You need to set your variables so they know where the information is coming from try something like this,

<?php 
$host="localhost"; 
$username="xxxx";   

$password="xxxx"; 
$db_name="a5286642_domino"; 
$tbl_name="gaestebuch";   

mysql_connect("$host", "$username", "$password")or die("cannot connect server "); 
mysql_select_db("$db_name")or die("cannot select DB"); 

$datetime=date("y-m-d h:i:s"); 

// You need to call your variables below (each have to link to a form field)

if(isset($_POST['submit'])) {
	$name    	   = $_POST['name-field']; 
	$email    	   = $_POST['emal-field']; 
	$comment   = $_POST['comment-field']; 

$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')"; 
$result=mysql_query($sql);