I do not see how the below two tables are related. A pivoted table would look like this: a b 1 2 3 4 5 6
a 1 3 5 b 2 4 6 If you are using Oracle you can pivot the table using sql*plus. If you are using MySQL then you'd need to load the table in an array (using Model->findall()) and then pivot the array using standard PHP. Shawn On Aug 14, 11:39 pm, Wimg <[EMAIL PROTECTED]> wrote: > how to pivot a table ? > > change > a b > 1 2 > 3 4 > 5 6 > > to > > c d e > 1 3 5 > 2 4 6 > ? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
