i'm doing my guest book now. when i click the button "sign!" in my guestbook.html, i get a result that is a blank page except the header only. i already check many times in my php coding but i still can't find the problems out... so if there free can help me to check my coding? thanks
<html>
<head>
<title>Guest Book Entry</title>
</head>
<body>
<h1>Guest Book Entry</h1>
<?php
// create short variable names
$name=$HTTP_POST_VARS['name'];
$location=$HTTP_POST_VARS['location'];
$email=$HTTP_POST_VARS['email'];
$url=$HTTP_POST_VARS['url'];
$comments=$HTTP_POST_VARS['comments'];
if (!$name || !$location || !$email || !$url || !$comments)
{
echo 'You have not entered all the required details.<br />'
.'Please go back and try again.';
exit;
}
$name = addslashes($name);
$location = addslashes($location);
$email = addslashes($email);
$url= addslashes($url);
$comments = addslashes($comments);
@ $db = mysql_pconnect('localhost','');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db('gpsGuestBook');
$query = "INSERT INTO guestbook values
('','$name','$location','$email','$url','$comments')";
$result = mysql_query($query)or die(mysql_error());
if ($result)
echo mysql_affected_rows().' guest inserted into database.';
?>
</body>
</html>
