PHP Forum

**fizanos** · 07:26 AM

Hello

I'm new and i need your help.

I need to create a report using start date and end date.

I created a form that gets the values Between those that and display accordingly unfortunately i need to perform addition on some values.

Date Distributor's ID Customer's Name Total Paid(Naira) Total Paid(Dollar)
2010-05-31 001 Sanyaolu 598,728.00 3,939
Grand Total =N=X $X

Code:

<table width="95%" border="1" align="center" CELLPADDING="2" CELLSPACING="0" bordercolor="<?PHP print "$BorderColour"; ?>">
          <tr valign="middle" class="tableheadsx">
            <td width="91" height="29" align="left" class="welcomexx"><strong>Date</strong></td>
            <td width="136" height="29" align="left" class="welcomexx"><strong>Distributor's ID </strong></td>
			<td width="136" height="29" align="left" class="welcomexx"><strong>Customer's Name </strong></td>
            <td width="140" height="29" align="left" class="welcomexx"><strong>Total Paid(Naira) </strong></td>
			<td width="157" height="29" align="left" class="welcomexx"><strong>Total Paid(Dollar)</strong></td>
          </tr>
		  <?php $rowShine = 1;?>
          <?php if ($totalRows_getPages > 0) { // Show if recordset not empty ?>
            <?php do { ?>
              <tr id="row-<?php echo $row_getPages['code']; ?>" <?php if($rowShine%2){
						echo "class=\"alternate\" ";
					}
			?>><?php $me=$row_getPages['totalDollar']; ?>
			<?php $mee=$row_getPages['totalNaira']; ?>
                <td height="25" align="left" valign="top" class="style1"><?php echo $row_getPages['xdate']; ?></td>
				 <td height="25" align="left" valign="top" class="style1"><?php echo $row_getPages['dis_id']; ?></td>
                <td height="25" align="left" valign="top" class="style1"><strong><?php echo $row_getPages['dis_name']; ?></strong></td>
                <td height="25" align="left" valign="top" class="style1"><?php print number_format($mee,2); ?></td>
				<td height="25" align="left" valign="top" class="style1"><?php print number_format($me); ?></td>
              </tr>
              <tr id="row-<?php echo $row_getPages['code']; ?>" <?php if($rowShine%2){
						echo "class=\"alternate\" ";
					}
			?>>
                <td height="25" align="left" valign="top" class="style1"><strong>Grand Total </strong></td>
                <td height="25" align="left" valign="top" class="style1">&nbsp;</td>
                <td height="25" align="left" valign="top" class="style1">&nbsp;</td>
                <td height="25" align="left" valign="top" class="style1"><img src="http://www.webmaster-talk.com/images/naira.jpg" width="9" height="11" />&nbsp;</td>
                <td height="25" align="left" valign="top" class="style1"><strong>$</strong></td>
              </tr>
              <?php $rowShine++;?>
              <?php } while ($row_getPages = mysql_fetch_assoc($getPages)); ?>
            <?php } // Show if recordset not empty ?>
        </table>

**tripy** · 05-31-2010, 07:12 AM

Just do that on your sql query.

Code:

select field1+field2 as sumField from yourTable

**fizanos** · 05-31-2010, 07:38 AM

thanks bro!

The problem is that the table is automatically generated so one can't know the number of field just like in a report

**chrishirst** · 05-31-2010, 08:29 AM

You replace "field1" & "field2" with the actual names of YOUR columns.

It's in 'pseudocode' and field1 & field2 are placeholders