Jump to content


Photo

Data to Array Manipulation


  • Please log in to reply
2 replies to this topic

#1 Crimpage

Crimpage
  • Members
  • PipPipPip
  • Advanced Member
  • 70 posts
  • LocationBrisbane, Australia

Posted 24 May 2006 - 11:03 PM

Hi All,

I'm making a report for work, and what we have is a table that has these fields we need to use:

Table:
- Office
- Broker Name
- Financier
- Client
- About 5 info columns

What I need to do, is turn that into an array that looks like:

Array (
- Office
- Broker Name
- Financier
-Client 1
- Info columns
- Client2
- Info columns


We need to do this so that we can break up the pages so that each broker has their own page etc.

Thanks for your help.

Crimpage.

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 24 May 2006 - 11:34 PM

Table? Do you mean database table. If so, why not SELECT data with a WHERE broker=something type of SQL query?
Legend has it that reading the manual never killed anyone.
My site

#3 Crimpage

Crimpage
  • Members
  • PipPipPip
  • Advanced Member
  • 70 posts
  • LocationBrisbane, Australia

Posted 25 May 2006 - 02:37 AM

Sorry, I probably should have worded it better.

Yes the info will be coming from a database. I have no problems with the query and if I don't need to create an array like this then that could be even better.

Basically, I need the report to be grouped together by the office, then broker, then financier.

So the report would look like:

Page1:
Office: Melbourne
Broker: Broker 1
Financier: Financier 1
Client 1 & Info
Client 2 & Info
Client 3 & Info
Financier: Financier 2
Client 4 & Info
Client 5 & Info

Broker: Broker 2
Financier: Financier 1 (same as number 1 above)
Client 1 & Info
Client 2 & Info
Client 3 & Info

Office: Sydney
and so on.

Thanks,

Crimpage.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users