paulclark

OK I ended up taking a break and solved the problem in my head. The missing ingredient was adding a self numbering ID to the virtual table I created from which I pull the data for each review. Without that there was no way to create a unique URL

Although I wasn't expecting to find a book that would provide all the code and the detailed instructions on how to adapt it to construct a dynamic website that does everything I need it to, this book came incredibly close. I am, however, at a dead end regarding perhaps the most crucial part of my grand puzzle. How to have user submitted content automagically appear in the index and create a link to itself? I created a signup page to become a user, and the login page that gets me (and me alone hopefully) to the data entry page where I can input the following to several tables on the database: Artist, Album Title, Album Review, Rating, Several Fields for Links (Artist Website, Label Website, Other Reviews, eCommerce Sites). When I click Submit it all goes up and the following appears at the top of the Reviews index: Artist, Album Title My First, Last, Date Submitted Synopsis (First paragraph of review, which will always be two lines long) I've figured out all the primary to foreign key links, joins Etc but I'm missing how submitting data can create a URL back to itself. I think that answer is in Chapter 19 but I'm just not seeing it. Thanks, PC