Help with MySql

[abbey]

hello,

i have a database that has a series of numbers that i want to add up and then divide and the result will be turn into a percentage amount.

i was wondering how would i go about doing this? thanks again everyone.

abbey

[sid]

i suppose the db looks like that:

table numbers
field value:
5
7
12
65
23
...

$query = "SELECT value FROM numbers";
$result = mysql_query($query);

$total = mysql_num_rows($result);

while ($row = mysql_fetch_array($result)) {
    $sum += $row[0];
}

$percent = sprintf("%0.2f", $sum/$count);

print "$percent" . "%";

i hope thats what you wanted - i didnt get the percentage part 100%... hehe - WHAT do you want the percentage of? right now it calculates the average value of the values in the table and prints it with 2 digits after the comma...

[mrmufin]

Gosh, if you're using MySQL, I can cut sid's solution down considerably:

$q = "SELECT AVG(value) FROM numbers";
$r = mysql_query($q);
if($r) {
	$avg = mysql_fetch_row($r);
	printf("%0.2d %%", $avg[0]);
}

[sid]

nerd! 😉 thanks - i guess i learned something again