I am in new cakephp. I am facing prob to developing a new module.
I have two tables;
Product table
Field Type Null Key Default Extra
product_id int(5) unsigned NO PRI
auto_increment
product_name varchar(45) NO
category_id int(5) unsigned NO
is_active enum('Y','N') NO Y
category table
Field Type Null Key Default Extra
category_id int(6) unsigned NO PRI
auto_increment
category_name varchar(45) NO
parent_id int(6) unsigned NO
is_active enum('Y','N') NO Y
Now I want to display the product list with category name. it is very
easy in general PHP(just using "select P.product_id, P.product_name,
C.category_name, P.is_active from products as P join categorys as C on
P.category_id=C.category_id"). How in cakephp
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
