Hi,
pls help me how to calculate two rows : income - expenses = profit.
what is the coding to get the result 'profit'.
Here is my website :
http://www.warisanmovers.com/pnl-list_records.php
<?php
$host="localhost"; // Host name
$username="warisanm_pnl"; // Mysql username
$password="warisan007"; // Mysql password
$db_name="warisanm_pnl"; // Database name
$tbl_name="income"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="17"><strong>WM Profit and Loss Monitoring Systems</strong> </td>
</tr>
<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>ITEMS</strong></td>
<td align="center"><strong>L.Year Avg</strong></td>
<td align="center"><strong>JAN</strong></td>
<td align="center"><strong>FEB</strong></td>
<td align="center"><strong>MAR</strong></td>
<td align="center"><strong>APR</strong></td>
<td align="center"><strong>MAY</strong></td>
<td align="center"><strong>JUN</strong></td>
<td align="center"><strong>JUL</strong></td>
<td align="center"><strong>AUG</strong></td>
<td align="center"><strong>SEP</strong></td>
<td align="center"><strong>OCT</strong></td>
<td align="center"><strong>NOV</strong></td>
<td align="center"><strong>DEC</strong></td>
<td align="center"><strong>Remarks</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo $rows['id']; ?></td>
<td><? echo $rows['B']; ?></td>
<td><? echo $rows['C']; ?></td>
<td><? echo $rows['D']; ?></td>
<td><? echo $rows['E']; ?></td>
<td><? echo $rows['F']; ?></td>
<td><? echo $rows['G']; ?></td>
<td><? echo $rows['H']; ?></td>
<td><? echo $rows['I']; ?></td>
<td><? echo $rows['J']; ?></td>
<td><? echo $rows['K']; ?></td>
<td><? echo $rows['L']; ?></td>
<td><? echo $rows['M']; ?></td>
<td><? echo $rows['N']; ?></td>
<td><? echo $rows['P']; ?></td>
<td><? echo $rows['Q']; ?></td>
</tr>
<?php
}
?>
<?php
$query = "SELECT B, SUM(C), SUM(D), SUM(E), SUM(F), SUM(G), SUM(H), SUM(I), SUM(J), SUM(K), SUM(L), SUM(M), SUM(N), SUM(P) FROM income";
$result = mysql_query($query) or die(mysql_error());
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo ""; ?></td>
<td><strong><? echo "INCOME"; ?></strong></td>
<td><strong><? echo $rows['SUM(C)']; ?></strong></td>
<td><strong><? echo $rows['SUM(D)']; ?></strong></td>
<td><strong><? echo $rows['SUM(E)']; ?></strong></td>
<td><strong><? echo $rows['SUM(F)']; ?></strong></td>
<td><strong><? echo $rows['SUM(G)']; ?></strong></td>
<td><strong><? echo $rows['SUM(H)']; ?></strong></td>
<td><strong><? echo $rows['SUM(I)']; ?></strong></td>
<td><strong><? echo $rows['SUM(J)']; ?></strong></td>
<td><strong><? echo $rows['SUM(K)']; ?></strong></td>
<td><strong><? echo $rows['SUM(L)']; ?></strong></td>
<td><strong><? echo $rows['SUM(M)']; ?></strong></td>
<td><strong><? echo $rows['SUM(N)']; ?></strong></td>
<td><strong><? echo $rows['SUM(P)']; ?></strong></td>
<td><? echo ""; ?></td>
</tr>
<?php
}
mysql_close();
?>
</td>
</tr>
<?php
$host="localhost"; // Host name
$username="warisanm_pnl"; // Mysql username
$password="warisan007"; // Mysql password
$db_name="warisanm_pnl"; // Database name
$tbl_name="expenses"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo $rows['id']; ?></td>
<td><? echo $rows['B']; ?></td>
<td><? echo $rows['C']; ?></td>
<td><? echo $rows['D']; ?></td>
<td><? echo $rows['E']; ?></td>
<td><? echo $rows['F']; ?></td>
<td><? echo $rows['G']; ?></td>
<td><? echo $rows['H']; ?></td>
<td><? echo $rows['I']; ?></td>
<td><? echo $rows['J']; ?></td>
<td><? echo $rows['K']; ?></td>
<td><? echo $rows['L']; ?></td>
<td><? echo $rows['M']; ?></td>
<td><? echo $rows['N']; ?></td>
<td><? echo $rows['P']; ?></td>
<td><? echo $rows['Q']; ?></td>
</tr>
<?php
}
?>
<?php
$query = "SELECT B, SUM(C) AS CB, SUM(D), SUM(E), SUM(F), SUM(G), SUM(H), SUM(I), SUM(J), SUM(K), SUM(L), SUM(M), SUM(N), SUM(P) FROM expenses";
$result = mysql_query($query) or die(mysql_error());
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo ""; ?></td>
<td><strong><? echo "EXPENSES"; ?></strong></td>
<td><strong><? echo $rows['SUM(C)']; ?></strong></td>
<td><strong><? echo $rows['SUM(D)']; ?></strong></td>
<td><strong><? echo $rows['SUM(E)']; ?></strong></td>
<td><strong><? echo $rows['SUM(F)']; ?></strong></td>
<td><strong><? echo $rows['SUM(G)']; ?></strong></td>
<td><strong><? echo $rows['SUM(H)']; ?></strong></td>
<td><strong><? echo $rows['SUM(I)']; ?></strong></td>
<td><strong><? echo $rows['SUM(J)']; ?></strong></td>
<td><strong><? echo $rows['SUM(K)']; ?></strong></td>
<td><strong><? echo $rows['SUM(L)']; ?></strong></td>
<td><strong><? echo $rows['SUM(M)']; ?></strong></td>
<td><strong><? echo $rows['SUM(N)']; ?></strong></td>
<td><strong><? echo $rows['SUM(P)']; ?></strong></td>
<td><? echo ""; ?></td>
</tr>
<tr>
<td><? echo ""; ?></td>
<td><strong><? echo "PROFIT"; ?></strong></td>
<td><strong><? echo $rows['SUM(C)']; ?></strong></td>
<td><strong><? echo $rows['SUM(D)']; ?></strong></td>
<td><strong><? echo $rows['SUM(E)']; ?></strong></td>
<td><strong><? echo $rows['SUM(F)']; ?></strong></td>
<td><strong><? echo $rows['SUM(G)']; ?></strong></td>
<td><strong><? echo $rows['SUM(H)']; ?></strong></td>
<td><strong><? echo $rows['SUM(I)']; ?></strong></td>
<td><strong><? echo $rows['SUM(J)']; ?></strong></td>
<td><strong><? echo $rows['SUM(K)']; ?></strong></td>
<td><strong><? echo $rows['SUM(L)']; ?></strong></td>
<td><strong><? echo $rows['SUM(M)']; ?></strong></td>
<td><strong><? echo $rows['SUM(N)']; ?></strong></td>
<td><strong><? echo $rows['SUM(P)']; ?></strong></td>
<td><? echo ""; ?></td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
mysql_close();
?>
