I am rendering a graph which picks values from the database the x axis picks the dates and the yaxis picks the values.
the mysql picks the variables for the values
the code is
$minSQL = "SELECT MIN(rate_value) As MinValue FROM $ratesTable";
$minResult = mysql_query($minSQL);
$myArray = mysql_fetch_array($minResult);
$minValue = $myArray['MinValue'];
$maxSQL = "SELECT MAX(rate_value) As ManValue FROM $ratesTable";
$maxResult = mysql_query($manSQL);
$myArray = mysql_fetch_array($manResult);
$maxValue = $myArray['ManValue'];
i pass the parameters to the $strParam like
------------------------------------
yAxisMinValue=$minValue;yAxisMaxValue=$maxValue;
---------------------------------------
thus the min and max values are picked and run correctly ,when the graph is rendered it shows a different max value
and it generates its own progression eg if i set a value of 520 and 522 the y axis picks all these values
521,537,552,568,584,600
where do these values {521,537,552,568,584,600} originate from and how do i tweak them to my own standard
My Script is attached below
Many thanks,
Benjamin Anangwe
Attached File(s)
-
smallchat.zip (2.04K)
Number of downloads: 44

Back to top
MultiQuote
