/* ASUKA's Guestbook */
print "
";
print "Connecting to ASUKA's Notebook database...";
MYSQL_connect("localhost","asukanote","eva020") or die("
A_ERROR 415: Unable to connect to the database. If the problem persists, contact Axel.");
Print "OK!";
Print "
Selecting the \"Guestbook\" section...";
@mysql_select_db("asukanote") or die("
A_ERROR 417: Unable to select the database. If the problem persists, contact Axel.");
Print "OK!
Here's the place where you can say what you think of my notebook! Don't be shy, I read every entry!
Sign my guestbook
";
$myquery = "SELECT * FROM angbook ORDER BY signdate DESC";
$queryresult = MYSQL_QUERY($myquery) or die("
A_ERROR 412: Unable to execute the query. If the problem persists, contact Axel");
$numrows = MYSQL_NUM_ROWS($queryresult);
$i4=0;
while ($i4 < $numrows){
$name = mysql_result($queryresult,$i4,"nom");
$email = mysql_result($queryresult,$i4,"email");
$homepage = mysql_result($queryresult,$i4,"homepage");
$comments = mysql_result($queryresult,$i4,"comments");
$referrer = mysql_result($queryresult,$i4,"referrer");
$signdate = mysql_result($queryresult,$i4,"signdate");
$ipadress = mysql_result($queryresult,$i4,"ipadress");
print"
Name: $name";
Print"
E-mail: $email";
Print"
Homepage URL: $homepage";
Print"
Comments about the site:$comments";
Print"
Where did you hear about this site?: $referrer";
Print"
This entry has been signed on $signdate from the IP adress $ipadress
";
$i4++; }
?>