Answered
PHP Code to perform calculations
How can one use php code to calculate an everage of all the
entries in a table column? I am sure this is easy but I have no
clue. I found this code on the net. I understand it but I am not
sure how i reference my database since it is referred to as a
require one line. so basically I am not sure what comes after the
"From" in the code below.
<?php
function average_value()
{
$query = "SELECT SUM(helpful) FROM evaluation";
$result = mysql_query($query);
// Number of people in the table
$num = mysql_num_rows($result);
$sum = mysql_result($result, 0);
$average = ($sum / $num);
$average = round($average, 1);
return 'The average score for Helpful is '.$average;
}
?>
Darren
<?php
function average_value()
{
$query = "SELECT SUM(helpful) FROM evaluation";
$result = mysql_query($query);
// Number of people in the table
$num = mysql_num_rows($result);
$sum = mysql_result($result, 0);
$average = ($sum / $num);
$average = round($average, 1);
return 'The average score for Helpful is '.$average;
}
?>
Darren
AdChoices