Math operation in PHP & MySQL

Question

I'm creating a table using a PHP from the MySQL query which return a total count of rows from two columns in the database, "total_tr" and "total_rc".

I've already done and successfully view the count in the PHP table, the coding is:

 while($row = mysql_fetch_array($result))
      {
            echo "<tbody>";
              echo "<tr>";
                  echo "<td>Zone</td>";
                  echo "<td>" . $row['segment_code'] . "</td>";
                  echo "<td>" . $row['COUNT(total_tr)'] . "</td>";
                  echo "<td>" . $row['COUNT(repeat_rc)'] . "</td>";
              echo "</tr>";
            echo  "</tbody>"; 
      }

My problem now is, I want to take the total count value of "total_tr", divided with total count of "repeat_rc" and multiply with 100 to get the percentage of total_rc.

Any ideas on how can I do that?

machineaddict · Accepted Answer · 2012-04-05 04:31:21Z

1

$myresult = $row['COUNT(total_tr)'] / $row['COUNT(repeat_rc)'] * 100;

answered Apr 5, 2012 at 4:31

machineaddict

3,2418 gold badges40 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

machineaddict Over a year ago

I'm glad I could help

Marc B · Accepted Answer · 2012-04-05 04:31:11Z

0

Keep a running count as you echo the rows

$total_tr = 0;
$total_rc = 0;
while($row = ...) {
    $total_tr += $row['COUNT(total_tr)']);
    $total_rc += $row['COUNT(repeat_rc)']);
    ... html here ...
}
echo $total_tr / $total_rc * 100;

answered Apr 5, 2012 at 4:31

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

Math operation in PHP & MySQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related