Multiple Search

[gunnit (Maric Gregor)]

I was wandering how to use the search that is in the model to perform the search on more than one table.

For example i have a table users and a table people , i want the search in the model User to search also in the table people, even though the 2 tables are not related by a foreign key.

Any tips or suggestions will be most appreshiated

[jayant (Codesutras)]

I was wandering how to use the search that is in the model to perform the search on more than one table.

For example i have a table users and a table people , i want the search in the model User to search also in the table people, even though the 2 tables are not related by a foreign key.

Any tips or suggestions will be most appreshiated

In your model class define first relation then use with property of CDbcriteria to search on related models.

Check this link

[gunnit (Maric Gregor)]

In your model class define first relation then use with property of CDbcriteria to search on related models.

Check this link

I do not have a relation between the 2 tables , can it still work