adding and array within an array

I think we need to see more of the code here - normally you'd just use as many foreach loops as needed to add everything up together.

HI Claire,

A foreach statement will not work because of the number of records that will be read - the file I'm attaching is an inventory program that is used to count the records based on the users preference from one to seven years. It will count the number of records by date and then calculates percentages month-by-month.

Records that have been marked as finished also contain a score from 400 to 1000. I need to capture the scores on each record that match the $where statement without the script timing out or exceeding the php cache settings.

Any suggestions would be appreciated.

Thanks - nmsinc

Okay, roughly how many records per query are you expecting for each user?

1000, to 10,000 per month x 12 months! - currently using a foreach(range(1,12)  statement!

Yeah, that's a bit excessive for a set of loops.

Basically this is a database problem, not a PHP problem. It's beyond what the CMSBuilder functions can do, but it can probably be solved with some custom SQL queries and table optimization. Unfortunately that puts it outside the scope of forum support - there's really no quick fix for this kind of issue.

If you want us to implement this for you, just send an email to consulting@interactivetools.com and link to this thread, we'll get you sorted.

Hi Claire,

I have sent two email requests to support as you asked on this issue and I have yet to receive a auto confirmation email which is typically within minutes!!

Thanks - nmsinc

Are you using this form? https://www.interactivetools.com/support/email_support_form.php

Hi there.

Got your email this time :)! Thanks for sending it again.  I am going to review this thread and get back to you  (via email) with my ideas as soon as I can.

In the meantime, for anyone else following along in this thread, this is a good time to remind you all that if you don't receive the auto confirmation email when sending in support or consulting requests, we might not have received your email. I recommend you post back to your thread just as a notification you sent an email so we know to be looking for it.

Thanks!