Add an entry
\n"; echo "

---

\n"; $query="select * from guestbook_entry order by WhenAdded DESC"; $res=mysql_query($query,$dbh); while ($row=mysql_fetch_array($res)) { echo 'Posted by: '.stripslashes($row["RealName"])."
\n"; echo "Message:
\n"; echo stripslashes($row["Message"])."

\n"; } break; // case view case "add" : echo "

"; ?> Real Name:
Email address:
Message:
Back to guestbook
\n"; break; // case submit default : break; // default } echo '

---

$Id: guestbook.php3,v 1.6 2000/07/20 02:45:25 jeff Exp $'; /* Database structure tables: guestbook_entry ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Email CHAR(255), RealName CHAR(255) NOT NULL DEFAULT "Anonymous", Message BLOB, When DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00", Visible INT NOT NULL DEFAULT 1) (each individual entry) */ ?>