I have a 3-tables

1-> categories = id,category_name
2-> statuses = id,status_name
3-> evnets = id,event_name,category_id,staus_id

events is the main table which has the id`s of categories and statuses table

I want to display events display where the names of categories and statuses 
is displayed instead of name

it is possible through join, but what should to model, controller and view 
to give the desired output.

The table must display event_id, event_name,category_name,status_name

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

Reply via email to