3 replies to this topic

[paulclark]

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

[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

[Larry]

Sorry for not replying earlier, but kudos for figuring it out and thanks for sharing your solution. So much to be said for stepping away from the computer sometimes!

[Marie]

What exactly do you mean by a self numbering ID - an auto incremental key?