Guestbook script

[kittielola]

I got a guestbook script from a site, everything seem to be working, besides the viewguestbook page, the entries not showing up, only the date/time. I am not sure if it the script that’s the problem or if I am not doing something right, because I am fairy new to php.

 

 

 

<?php

$host=""; 
$username=""; 
$password=""; 
$db_name=""; 
$tbl_name="guestbook"; 

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 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(); //close database
?>