Hi,

I'm having problems with my script so I need a little help...

I have two data sources, first is a MySQL DB with this colums:

HOUR DATE DATA
00:00 2012-05-07 5000
00:15 2012-05-07 6000
00:30 2012-05-07 3000
00:45 2012-05-07 7000
01:00 2012-05-07 3000


and a CSV file with this structure

HOUR MIN MAX
00:00 1000 10000
00:15 2000 7000
00:30 500 7000
00:45 100 5000
01:00 1000 4500

What is the script for?

The script gets the MySQL values for DATA and HOUR and print a line with the values for DATA, and an ABSCISA of HOUR, easy

Then, it imports a CSV file with HOUR, MIN and MAX values, like a threshold for the data each HOUR value, so this is perfectly working.

Both of MySQL and CSV data, has exactly 96 rows every day (96/4 = 24 hours a day)

I have an obiously problem, the CSV has static values that never changes, so it ALWAYS have 96 rows, but, sometimes, I cannot insert a value into MySQL so maybe that day will have 67 rows, when this happens, I have an abscisa with hours, and a line with data values for MySQL, but, a threshold line which does not correspond with the hour value, this is an example.


MYSQL
HOUR DATE DATA
00:00 2012-05-07 5000
00:15 2012-05-07 6000
01:00 2012-05-07 3000


CSV
HOUR MIN MAX
00:00 1000 10000
00:15 2000 7000
00:30 500 7000
00:45 100 5000
01:00 1000 4500

With this data, I will have a chart with messed values, because I have nothing for 00:30 and 00:45, but it will draw a threshold line with thresold values for incorrect times... I can't set VOID values to MySQL because it is an automated process...

I don't know if I explained very good, but... Basicaly what I need to do is this:

Compare both HOUR values, from MySQL and CSV, if this values are not the same, don't draw that CSV row and skip to next row. Any ideas?

This is my code

also you asked weeks ago and I don't know whether your problem is solved or not:

you can't use the csv import function if your csv files are not identically in structure

you have to open and imort the files "manually" into arrays with php (3 arrays: point-of-time, min-value, max-value)

create an extra array to set the abscissa: $hrs with the 15-min-values for the abscissa, there will be actually 97 items because you need a zero at the beginning and a 24 at the end (later just duplicate the corresponding data value of 0:00 for 24:00)

then you have to manipulate your imported data to fit into these structure

set the VOID constant for all missing data to make sure you have always 97 min and 97 max values

if your csv shows the gaps like this
HOUR MIN MAX
00:00 500 800
00:15
00:30 750 900

it should be quite easily done to get valid series data like
$HOUR = array ('00:00', '00:15', '00:30', ...);
$MAX = array (800, VOID, 900, ...);
$MIN = array (500, VOID, 750, ...);

if not, you must check each data-triple against the abscissa array $hrs for matches at the single points of time, because your array length is different from 96

don't forget to copy the 00:00 data to be used also with 24:00