Something like this should get you moving...
$ii = count($a);
$arrNew = array();
for ($jj = 0; $jj < $ii; $jj++)
{
$arrNew[] = array($a[$jj], $b[$jj]);
}
pr($arrNew);
Good luck!
Shawn
On Aug 15, 9:42 pm, Wimg <[EMAIL PROTECTED]> wrote:
> my problem is that I store my data as
> a b
> 1 2
> 3 4
> 5 6
>
> in database , but in my view i want to display it in a table like
>
> c d e
> 1 3 5
> 2 4 6
>
> On Aug 15, 10:26 pm, starkey <[EMAIL PROTECTED]> wrote:
>
> > I'm guessing this has something to do with your earlier post about
> > users and groups? If you could provide a little more detail on the
> > problem maybe I can provide a little more detail on a solution.
>
> > Shawn
>
> > On Aug 15, 10:24 am, starkey <[EMAIL PROTECTED]> wrote:
>
> > > 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
> > > > ?- Hide quoted text -
>
> > - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
