I am building a calendar which will show items from multiple tables.
For example i Have this
event1: 2/2/09 1pm
event2: 2/3/09 2pm
class1: 2/4/09 3pm
class2: 2/9/09 5pm
I am using the find all method and it returns this type of array
array(1) {
[0]=>
array(1) {
["Events"]=>
array(4) {
["id"]=>
string(3) "967"
["title"]=>
string(17) "event1"
["date1"]=>
string(10) "2009-02-15"
["timestart"]=>
string(8) "14:00:00"
}
}
}
and the second array instead of being called Events, is called
Classes. what is the best way to merge these together for sorting?
Should I write a union query and let mysql handle the work?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
