Re: Working on a Subsummary Report

On 12/17/2011 6:14 PM, DealTek wrote: >>> >> >> for the above to work right, you will need to loop through the mysql result set >> one time. Placing all the results in to one large array. Then you can loop >> through the array as many times as needed. >> >> What you will probably find is that you can sort all the data into the proper >> order withing your SQL statement. Then display the data looping through the >> mysql result set once without having to create the additional array mentioned in >> my first statement above. > > > > Thanks Jim, > > I will look into how to make this work with arrays... > > more beginner questions... > > - as stated - when I try to loop through 2x ... > - the table 2 only shows 1 record.. > - Q: ... like the query number row number? needs to be reset - but how? > > So is it not possible to loop more than 1x? Is that why we are loading into array? Exactly > > > -- > Thanks, > Dave - DealTek > dealtek@gmail.com > [db-11] -- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/ http://www.bendsource.com/