Jump to content
Larry Ullman's Book Forums

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 months later...

  • Create New...