Re: How to fill an array from multiple row in a db

2009-09-30 Thread Bruce Ferrell
Jim Gibson wrote: > On 9/30/09 Wed Sep 30, 2009 11:33 AM, "Bruce Ferrell" > scribbled: > >> >> Shawn H Corey wrote: >>> Bruce Ferrell wrote: I have a database (mysql if it matters) and I can select columns and rows from it no problem. what I can't quite seem to see how to do is to

Re: How to fill an array from multiple row in a db

2009-09-30 Thread Jim Gibson
On 9/30/09 Wed Sep 30, 2009 11:33 AM, "Bruce Ferrell" scribbled: > > > Shawn H Corey wrote: >> Bruce Ferrell wrote: >>> I have a database (mysql if it matters) and I can select columns and >>> rows from it no problem. what I can't quite seem to see how to do is to >>> take the columns I can

Re: How to fill an array from multiple row in a db

2009-09-30 Thread rkb
Bruce Ferrell wrote: > [snip] > > OK if I read these right and I understand the results of > my experiments > correctly, this: > > @rtn = $sth->fetchrow_array(); > > is giving me an array with two elements and this: > > push @data, [ @rtn ]; > > is giving me an array of 2 element arrays. Not good

Re: How to fill an array from multiple row in a db

2009-09-30 Thread Shawn H Corey
Bruce Ferrell wrote: OK if I read these right and I understand the results of my experiments correctly, this: @rtn = $sth->fetchrow_array(); is giving me an array with two elements and this: push @data, [ @rtn ]; is giving me an array of 2 element arrays. Not good as what I want is 2 arrays

Re: How to fill an array from multiple row in a db

2009-09-30 Thread Bruce Ferrell
Shawn H Corey wrote: > Bruce Ferrell wrote: >> I have a database (mysql if it matters) and I can select columns and >> rows from it no problem. what I can't quite seem to see how to do is to >> take the columns I can select and put them into a 2 dimensional array. >> >> I tried this: >> >> @data

Re: How to fill an array from multiple row in a db

2009-09-30 Thread Shawn H Corey
Bruce Ferrell wrote: I have a database (mysql if it matters) and I can select columns and rows from it no problem. what I can't quite seem to see how to do is to take the columns I can select and put them into a 2 dimensional array. I tried this: @data = $sth->fetchrow_array(); and it got a t

How to fill an array from multiple row in a db

2009-09-30 Thread Bruce Ferrell
I have a database (mysql if it matters) and I can select columns and rows from it no problem. what I can't quite seem to see how to do is to take the columns I can select and put them into a 2 dimensional array. I tried this: @data = $sth->fetchrow_array(); and it got a two dimensional array o