Hello Folks,
I have been stumbling with this problem for over 3 weeks trying various methods, with no luck and would apprciate any help.
I'm working with jpgraph creating stock charts.
$range = 90;
SELECT close FROM aseStockPrices where (reutersSymbol = '$symbol_A') AND (closeDate <= '$todaysDate') ORDER BY closeDate DESC LIMIT 90;
$i = 1;
while ($data3_A=mysql_fetch_array($result3_A)){
$price_A[$i] = $data3_A[0];
$i ++;
}
This works great when I hand code my array:
$ydata_A = array($price_A[90],$price_A[89],$price_A[88],$price_A[87],$price_A[86],$price_A[85],$price_A[84],$price_A[83],$price_A[82],$price_A[81],$price_A[80],$price_A[79],$price_A[78],$price_A[77],$price_A[76],$price_A[75],$price_A[74],$price_A[73],$price_A[72],$price_A[71],$price_A[70],$price_A[69],$price_A[68],$price_A[67],$price_A[66],$price_A[65],$price_A[64],$price_A[63],$price_A[62],$price_A[61],$price_A[60],$price_A[59],$price_A[58],$price_A[57],$price_A[56],$price_A[55],$price_A[54],$price_A[53],$price_A[52],$price_A[51],$price_A[50],$price_A[49],$price_A[48],$price_A[47],$price_A[46],$price_A[45],$price_A[44],$price_A[43],$price_A[42],$price_A[41],$price_A[40],$price_A[39],$price_A[38],$price_A[37],$price_A[36],$price_A[35],$price_A[34],$price_A[33],$price_A[32],$price_A[31],$price_A[30],$price_A[29],$price_A[28],$price_A[27],$price_A[26],$price_A[25],$price_A[24],$price_A[23],$price_A[22],$price_A[21],$price_A[20],$price_A[19],$price_A[18],$price_A[17],$price_A[16],$price_A[15],$price_A[14],$price_A[13],$price_A[12],$price_A[11],$price_A[10],$price_A[9],$price_A[8],$price_A[7],$price_A[6],$price_A[5],$price_A[4],$price_A[3],$price_A[2],$price_A[1]);
But not very effective when I try and change the $range. Can anyone recomend another method, something more dynamic where I don't have to hand code the second $ydata_A array?
Thanks,
Mike
