[ciapug] Multi-dimensional array

[Chris Hettinger]

As I loop through a result set I test each row, and for each row that =
passes, I need to record the information from 3 of the fields in the =
result set. Once I reach the end of my result set I need to look at the =
array of information, and count the number of records that had matched. =
Then I have a additional test I can run if I have more than one 1 row in =
my array. The goal is to find a 'single' match within a set of =
information that can in many cases have multiple results that can =
contain nearly exact information... Think, medical information where the =
only difference at times is the date on a policy, either it's active or =
not... or multiple policies for an individual...much of the information =
I have can be the same.

To do this I believe I need to use a multi-dimensional array, but I am =
not sure how to go about implementing this. My knowledge of arrays is =
low, and the doc's I have read haven't cleared this up for me.

For an example say the fields are
1) SSN
2) Birth date
3) Date Joined

So say I have 3 records pass my tests I need to record
=09
ssn                dob              joined
111-11-1111   1990-03-05    2003-01-01
222-22-2222   1990-03-05    2001-03-07
333-33-3333   1990-03-05    1987-12-23

When I count the array, I need to know I have 3 records.

What I am hoping for here, is a example of how to create this array, and =
how to properly index it so I can count the rows properly.



-Chris Hettinger, Web Specialist
-IFMC/ENCOMPASS
-www.encompas.com
-(515) 279-8730



CONFIDENTIALITY NOTICE:  This communication, including any attachment, =
may contain confidential information and is intended only for the =
individual or entity to whom it is addressed.  Any review, =
dissemination, or copying of this communication by anyone other than the =
intended recipient is strictly prohibited.  If you are not the intended =
recipient, please contact the sender by reply email, delete and destroy =
all copies of the original message.'