require("setup.php");
$link=mysql_connect("$server", "$dblog", "$dbpass");
if (!$link) die ("Couldn't connect to MySQL");
mysql_select_db("$admin_db",$link) or die (mysql_error(). " : ".mysql_errno());
if (isset($update))
{
// date of last user visit
$day1=date(d);
$month1=date(m);
$year1=date(Y);
$post_date=$year1."-".$month1."-".$day1;
$sql = "insert into guestbook (login, message, post_date) values('$username', '$message', '$post_date')";
$result = mysql_query($sql) or die("Couldn't execute query $sql.");
echo "Added !
";
}
print"Guestbook
";
print"
";
$sql2="SELECT * FROM guestbook";
$result2 = mysql_query($sql2) or die("1 Couldn't execute query.");
$num_rows=mysql_num_rows($result2);
$rowct = 0;
print"";
print"| Date | Username | Message |
";
while($row2=mysql_fetch_object($result2)):
$rowct++;
if ($rowct % 2 == 0 ){
print"| $row2->post_date | $row2->login | $row2->message |
";
}
else {
print"| $row2->post_date | $row2->login | $row2->message |
";
}
endwhile;
print"
";