chart column max number

[arcgotic]

Hi!
i have to generate charts and i dont know the range of the results i will display on this chart. can be 0- 22 or 0- 21687. i need a function that retreieves a number suitable for top value of my chart( 50 or 25000 for example).

[TomD]

mysql_num_rows ?

[weekender]

if the data is from a database

$sql = "SELECT MAX(value) FROM table";

if the data is in an array

//define the array
$numarray = array (19, 0, 4, 39, 17);

//sort the array, lowest to highest
sort($numarray);

//count the number of items in the array
$items = count($numarray);

//max is the last item in the sorted array (which is $item - 1, as arrays start at 0
$max = $numarray[$items-1];

//echo the maximum
echo "Max is " . $max;

[arcgotic]

10x weekender, but i need some "nice" values. for example i have this array (9, 34, 430, 45890). i need this nice values that will be placed on the top of the chart🙁10, 50, 500, 50000). in other words, the next "round" value higher than my max value in a column (10 for my max. 9, 50 for my max. 34 and so on)

[Weedpacket]

Originally posted by weekender

//define the array
$numarray = array (19, 0, 4, 39, 17);

//sort the array, lowest to highest
sort($numarray);

//count the number of items in the array
$items = count($numarray);

//max is the last item in the sorted array (which is $item - 1, as arrays start at 0
$max = $numarray[$items-1];

//echo the maximum
echo "Max is " . $max;

[/B]

Or

 echo "Max is ".max($numarray);

Originally posted by arcgotic
10x weekender, but i need some "nice" values.

In that case you're going to take the numbers you've got and find "nice" versions of them (whatever your idea of "nice" is). Looking up [man]round[/man] might be a good place to start. Maybe divide by 200, round (or just cast to an integer), then multiply back up by 200.

[arcgotic]

i resolved my problem.here is what i came up with:

function getChartMaxValue($number){
//define an array of "nice values"
$chartMaxNumber=array(1,5,10,50,100,250,500,750,1000,2000,5000,10000,15000,25000,50000,75000,100000,200000,500000,1000000,2000000,5000000,10000000);
asort($chartMaxNumber);
reset($chartMaxNumber);
if ($number<=$chartMaxNumber[0]) {return $chartMaxNumber[0];}
$i=count($chartMaxNumber);
for($j=0;$j<$i;$j++){
if (($number>$chartMaxNumber[$j])&&($number<=$chartMaxNumber[$j+1])) return $chartMaxNumber[$j+1];
}
}

it works fine for me. 10x again for replies. HAve fun!