Before spending loads of time on this, wouldn't Product.id and Fav.product_id be the same? Why can't you just join on these fields?
Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 13 Jul 2010, at 01:56, brototyp wrote: > Hi guys, I'm pretty new in Cake and I have an issue with connecting > two tables. > > I have a product table (product) with: > > id (auto increment), zupid (a unique product id key), productname, > product_id, product price ......... > > and an other table (favs) with: > > id (auto increment), zupid, user_id, stats. > > > Now I would like to connect those tables somehow with zupid as key (it > has to be zupid). > The reason for connecting is, that I want to have all product data > when accessing the fav table in the favs view. > So far, I only get the data from the favs table. > > Thanks in advance! > Best, > b > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group at > http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en