Difference between two query

Question

I have a question, it is possible to difference (mathematic operation) between two results?

Here is the code:

<?php 

$row = $query->row();

echo "<b>Your total expenses:</b><br />". $row->TotalExpense;

 ?>



<?php 

$row = $query2->row();

echo "<b>Your total incomes:</b><br />". $row->TotalIncome;

 ?>

Can I make something like:
TotalIncome - TotalExpense?

    <?php

$x = query2

$y = query1



echo $x - $y;

?>

Thanks!

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

If your start point is right. You kind of already had it.

<?php 
$TotalExpense = $query->row()->TotalExpense;
$TotalIncome = $query2->row()->TotalIncome;

echo "<b>Your Balance:</b><br />". ($TotalIncome - $TotalExpense);
 ?>

Difference between two query

Sign up