|
| |
|
|
badmojoman
Posts: 9
Joined: 6/23/2006
Status: offline
 |
"Dynamic" geustbooks? - 7/11/2006 20:19:47
Hi all,
I want to know if it's possible to create 'dynamic' guestbooks. What I'm looking to do is as follows:
1 - I have a database of book reviews. I've created an .asp page that retrieves the full list of books only.
2 - When a visitor clicks on the name of the book, it opens up a separate page (based on a template) that retrieves the specifics about the book (author name, ISBN, etc...)
What I'd like to do is to add a way for people to add comments to the individual books pages, so I figured a 'guestbook' is the best way to do this. However, I can't figure out is how to add a 'dynamic' guestbook to the page template so that, even if I add new books, the new pages created from those books will have a section for people to add their comments.
Is this possible with guestbooks? And am I on the right track with the concept of 'dynamic' guestbooks?
Thanks so much in advance - this forum has been *very* helpful to me already!
|
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: "Dynamic" geustbooks? - 7/11/2006 21:12:36
I would create a table in my database called, user_reviews. In the table would be a primary key (autonumber), called reviewID. Also, include to foreign keys, which would be numeric and represent the id of the book and the id of the user. The final field would be a memo field, review_text. Then create a form that allows the user to submit his review and posts to this new table. Should be quite straight forward. If you have further questions, you may wish to post them in the database section as this would likely require a database solution.
Good luck.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
