Re: Re: jpgraph and mysql passing array

On Sat, Mar 26, 2011 at 9:44 PM, Brian Smither <bhsmither@gmail.com> wrote: > Would you try an experiment? Thanks for for the suggestion but this didn't seem to work. I beleive it is a header conflict based on what I have researched. I just can't seem to find a solution. > > In this line: > $sql = ("SELECT * FROM evdobanding WHERE Market like '%$term' and Cell_Sect = > '$term2' and Date = '$term3' ORDER BY distance asc"); > > Change to: > $sql = "SELECT * FROM evdobanding WHERE Market like '%".$term."' and > Cell_Sect = '".$term2."' and Date = '".$term3."' ORDER BY > distance asc"; > > That is, remove the parenthesis and concatenate the variables into the string. > The code in the PHP block: echo "TEST DATA PRINT"; print_r($datay,false); is passing all the values from the sql query because I can see them on the page with the jpgraph error. For example: TEST DATA PRINTArray ( [0] => 665 [1] => 7093 [2] => 30000 [3] => 45816 [4] => 70848 [5] => 41365 [6] => 35676 [7] => 22434 [8] => 5450 [9] => 29131 [10] => 35244 [11] => 48614 [12] => 51748 [13] => 55497 [14] => 79042 [15] => 732 [16] => 1375 [17] => 1094 [18] => 897 [19] => 1122 [20] => 3059 [21] => 5350 [22] => 5080 [23] => 3082 [24] => 2737 [25] => 326 [26] => 1334 [27] => 736 [28] => 469 [29] => 127 [30] => 105 [31] => 111 [32] => 197 [33] => 208 [34] => 950 [35] => 9 [36] => 9 [37] => 19 [38] => 8 [39] => 17 [40] => 90 [41] => 1917 [42] => 1289 [43] => 2051 [44] => 1534 [45] => 1 [46] => 2 [47] => 4 [48] => 4 [49] => 7 [50] => 8 [51] => 9 [52] => 18 [53] => 22 [54] => 5 [55] => 3 [56] => 1 [57] => 1 [58] => 2 ) JpGraph ERROR 25121 From the research I have done so far using Jpgraph I have found this link to a similar issue: http://ubuntuincident.wordpress.com/tag/jpgraph/ but I am unable to get my arrays from the sql query to populate the graph. Thank you in advance, Chris