Please Help Me. 3 Models Display In View

Yii 1.1 General Discussion
1

I have 3 models.

[+] REGION

  • ID

  • NAME (FK)

[+] COUNTRY

  • ID

  • NAME

  • REGION_ID (FK)

[+] CITY

  • ID

  • NAME

  • COUNTRY_ID (FK)

and I want to display region’s name in view’s city

EXAMPLE

===============================

CITY NAME || COUNTRY || REGION

===============================

New York || USA || America

Bei Jing || China || Asia

Tokyo || Japan || Asia

What should I do?

2

this might help you how relationships work in yii please do take a look

http://www.yiiframework.com/doc/guide/1.1/en/database.arr