[RESOLVED] need coding help for calculation..

[chinna]

hi there..let me explain... first i type all my expenses in database for day one...and its goes for to day two and so on.....how i do the calculation...how do i call the data and do the coding..?...please help me..

---

hates make waste

[chinna]

i have try use this code but no display...

<?php
function addTotal()
{
$sql="select amount from details";
$result=mysql_query($sql)or die(mysql_error());
while($r=mysql_fetch_assoc($result))
{
@$expenses=$r['expenses'];
@$total=$expenses+$total;
}
}
?>

[leatherback]

Hi,

What yu did should in theory work. What didn't work?

Try this:

$query = "select sum(amount) as total from details group by DAYCOLUM";
$result=mysql_query($query)or die(mysql_error());
while($row=mysql_fetch_aray($result))
  {
  echo $row['total']."<br />";
  }