Hi, I have a big wonder about implementing a simple search form in my CakePHP application. Let's say we have 4 related tables (models): countries(id, name), customers(id, first_name, surname), years(id, year) and customer_years(id, year_id, customer_id, data). They have associations:
customers *belongsTo* countries (aka countries *hasMany* customers) customers *hasMany* customer_years (aka customer_years *belongsTo* customers) years *hasMany* customer_years (aka customer_years *belongsTo* years) We can make and association like HABTM for years and customers, but I don't think it's necessary. So the question is how to search for customer with name John from Gemany who has data between 2001 and 2005 year. I have made a controller who uses all related models and a corresponding function with view but wonder how to make search_strings/ queries. --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
