Storing the Guestbook Entries
Because we want to store the various guestbook entries made by visitors to our Web site, we'll need to store each user's guestbook entry in a database table. Each separate piece of information we need to store concerning a guestbook entry should become a column in the database table, with an appropriate column type. Let's take a moment to review what needs to be stored with each guestbook entry:
The user's name
The user's e-mail address
The user's message
The date and time the guestbook entry was made
The user's name, e-mail address, and message will be strings, so we'll want to use appropriate-length varchar column types. A DateTime column type will suffice for the date and time the guestbook entry was made.
We need ...