Hi all, Apologies for this newbish question, I've searched for hours trying to resolve this with no joy so would appreciate it if you could point me in the right direction.
I'm trying to setup a simple website (my first cakephp project, having become OKish at PHP/MYSQL). Basically there are three models so far, posts, categories and sites (all of the databases follow cake naming conventions, with id as PK, name and _id for FKs. Posts belong to categories. Posts also belong to sites. Categories, and sites have one post. I have used cake bake to generate the controllers and views. /posts/ works great, and it shows everything by name, the "add" works great in terms of the relationships. The problem I am having is, when I go to /categories/, it brings up posts under that category and the "category" and "site" are showing up as numbers rather than "name" (in the view they are category_id, and site_id). I can get the category name to show up OK (because I think that table is mapped). What I don't understand is why the name is not showing in place of the _id like everwhere else. How can I output database fields in another model. It is probably something really simple, but I'm getting used to the cake way of thinking. Is it that the relationship is wrong? The query at the bottom shows the "names" are being selected. Thanks in advance --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
