Thank you for the help on the database normalization, I will give it some more thought. The book id field is actually a composite key that contains the book number, chapter number, and paragraph number, which can be exploded to decifer. The entire book(s) will be in the database and I wanted to take advantage of mySQL full text search function, and at current it didn't make sense to start splitting tables for each book even those this is not currently normalized.
It would be really nice to be able to display a paragraph by simply calling; echo $this->CustomHelper->quotePara($id); without having to write a find query in a model, set the variable in the controller, then display the variable in the view everytime I want to display a paragraph on the website. I am kinda new at this for sure (comp programming, PHP, cake, etc.) as it's just a hobby. Maybe there is no such animal. I was hoping a custom helper/component/ behavior whatnot would clean up my program making less repeat coding. In my custom helper I would also have functions to return the book title, chapter number, page number, paragraph number, etc., and format and link to view the source page, chapter, book, neighbors, etc. Thanks for the help, things are becoming clearer as I think on it. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
