foreach ($xrange as $i => $j) { $data[$_LABELS['total']][$j['date']] = 0; $data[$_LABELS['tblClients.gender.F']][$j['date']] = 0; $data[$_LABELS['tblClients.gender.M']][$j['date']] = 0; $data[$_LABELS['tblLoanTypes.borrower_type.B']][$j['date']] = 0; $data[$_LABELS['tblLoanTypes.borrower_type.I']][$j['date']] = 0; } // populate data array() with actual values from sql foreach ($mrow as $key => $val) { $data[$_LABELS['total']][$val['date']] = $val['clients']; $data[$_LABELS['tblClients.gender.M']][$val['date']] = $val['male']; $data[$_LABELS['tblClients.gender.F']][$val['date']] = $val['female']; $data[$_LABELS['tblLoanTypes.borrower_type.I']][$val['date']] = $val['client_i']; $data[$_LABELS['tblLoanTypes.borrower_type.B']][$val['date']] = $val['client_b']; } foreach ($data as $key => $val) { $c = 1; foreach ($val as $i => $j) { $dataf[$key][$c++] = $j; } } //print('<pre>');print_r($dataf);print('</pre>'); exit; $options['y-round'] = 0; $options['x-labels']['on'] = 0; $options['x-labels']['alt'] = sprintf($_LABELS['from_x_to_y'], $xmin, $xmax); $graph = new Graph('', $_LABELS[$_GET['cycle']], $_LABELS['RP.GRP.Performance.clientPortfolio'], $dataf, $options); Graph::printLines($graph); ?>