kittielola Posted October 4, 2008 Share Posted October 4, 2008 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 ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.