[RESOLVED] sum / adding a looped result

[vinny199]

Hello,

Im trying to calculate the total amount of tickets sold to an event.

My recordset rs_report returns the correct data and I loop the results so I can see each tickets sold, at what time, date etc.

What I dont know how to do is how to calculate the toatal amount of tickets sold

For instance my query would return:

date / ticket sold

2007/20/03 10
2007/19/03 1
2007/19/03 3
2007/19/03 1

ETC.

What I would like to do, at the bottom of my table is to display that 15 tickets have been sold for that event

my ticket quantity row is:

 echo $row_rs_report['Quantity']; 

Could you pls help?

Thanks,

Vinny

[leatherback]

how do you retrieve your results?

I assume you have some form of:

while($row = mysql_fetch_array($result))
{
// do stuff
}

do:

$total = 0
while($row_rs_report = mysql_fetch_array($result))
  {
  $total = $total + $row_rs_report['Quantity']; 
  }

[vinny199]

Thanks,

but no luck.

here is what I have

(I have tried placing the $total = 0 in and outside the loop and with without ''. same result)

                          

						 do { ?>
                         <table width="663" border="0" align="center" cellpadding="2" cellspacing="2" class="table_04_navigation">
                           <tr>
                             <td width="161" nowrap class="text_02_titles"><strong><img src="../images/main/dot_orange_small.jpg" alt="bullet point" width="9" height="9" align="absmiddle"> </strong><span class="twelve"><strong><?php echo $row_rs_report['Organiser']; ?></strong></span></td>
                             <td width="220" nowrap class="text_03_micro"><?php echo $row_rs_report['Name']; ?></td>
                             <td width="60" nowrap class="text_03_micro"><?php echo $row_rs_report['Quantity']; ?> ticket(s)</td>
                             <td width="173" nowrap class="text_03_micro"><?php echo KT_formatDate($row_rs_report['Stampdate']); ?></td>
                             <td width="70" nowrap class="text_02_titles">&nbsp;</td>
                           </tr><?php $total = '0'; ?>
                         </table>
                         <?php }  while ($row_rs_report = mysql_fetch_assoc($rs_report));
						 {
						    $total = $total + $row_rs_report['Quantity']; } ?>                         <br>
                        <?php echo $total ?><br>

[leatherback]

But you are already retrieving the data for the table right?

So..

<?php
$total = '0'; 

// I am not sure why you have a DO here.. 
// I would have expected a while. But ok.. Cannot see how you deal with it. If it works, it works
do { 

$total = $total + $row_rs_report['Quantity']; 

 ?>

                <table width="663" border="0" align="center" cellpadding="2" cellspacing="2" class="table_04_navigation">
                       <tr>
                         <td width="161" nowrap class="text_02_titles"><strong><img src="../images/main/dot_orange_small.jpg" alt="bullet point" width="9" height="9" align="absmiddle"> </strong><span class="twelve"><strong><?php echo $row_rs_report['Organiser']; ?></strong></span></td>
                         <td width="220" nowrap class="text_03_micro"><?php echo $row_rs_report['Name']; ?></td>
                         <td width="60" nowrap class="text_03_micro"><?php echo $row_rs_report['Quantity']; ?> ticket(s)</td>
                         <td width="173" nowrap class="text_03_micro"><?php echo KT_formatDate($row_rs_report['Stampdate']); ?></td>
                         <td width="70" nowrap class="text_02_titles">&nbsp;</td>
                       </tr>
                     </table>
<?php 
echo "<br /> $total";
?>

[vinny199]

Thank you Leatherback.

thats perfect!

Vinny