"Dynamic" geustbooks? (Full Version)

All Forums >> [Web Development] >> General Web Development



Message


badmojoman -> "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 -> 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.




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875