Color and Product are hasAndBelongsToMany to each other
Product belongsTo Category
Category hasMany Product
I'm using this code to show products by color:
$this->Product->Color->id = $color_id;
$data = $this->Product->Color->read();
$this->set('products', $data['Product']);
this returns this array:
Array
(
[0] => Array
(
[id] => 51
[title] => Pink Polka dot Headband
[description] => This is our best selling headband! We
start with a stretch cotton headband that is oh so comfy, then top it
off with an adorable light pink and white polka dot grosgrain bow. This
bow has a pink and white knotted center. This headband is a classic
and one your little girl will wear for years! Fits ages 4 months - 4
years.
[inventory] => 2
[price] => 4.99
[category_id] => 1
[sale_date] => 0000-00-00
[sale_price] => 0
)
[1] => Array
(
[id] => 52
[title] => Double Ruffle Satin Bow
[description] => How could you live without this one?
Bowhead Babies favorite bow of all, the double ruffle satin bow. This
bow is perfect for dresses and casual play clothes. It has a matching
satin knotted center and covered scissor clip back. This bow measures
3" and is great for newborn to toddler girls. It looks great in a lace
headband or in pigtails! Look at our 5 piece set deal!
[inventory] => 5
[price] => 3.99
[category_id] => 1
[sale_date] => 0000-00-00
[sale_price] => 0
)
)
I would like to be able to return category.title to the view also. How
do I do this?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---