Very new to this and trying to adapt some code so that I can print the sum of a variable in a loop. If anyone can assist I would be eternally grateful.
I want to add the values of (integer) $pax_number, then print out that total after the loop has stopped.
Here's the page: http://www.availabilities.co.uk/hdhc9.php
And here's the code:
<?
//Change Today's date to any date in the future
$tomorrow = mktime(0,0,0,date("m"),date("d")+4,date("Y"));
echo "BOOKINGS FOR DATE: " .date("d-m-Y", $tomorrow);
$SQL = "SELECT * FROM tables WHERE booking_date= '" .date("Y-m-d", $tomorrow). "' ORDER BY booking_date ASC, time ASC";
//Shows bookings from a specific date only
$recordSet = &$conn->Execute($SQL);
if ($conn->ErrorNo() > 0)
print "<hr><pre>An error occurred searching the database!<br>Error Msg: ".$conn->ErrorMsg()."</pre><hr>";
elseif (!$recordSet->EOF && isset($recordSet->fields[0])) {
while (!$recordSet->EOF) {
$ff_id=$recordSet->fields("ff_id");
$book_cancel=$recordSet->fields("book_cancel");
$booking_date=$recordSet->fields("booking_date");
$pax_number=$recordSet->fields("pax_number");
$time=$recordSet->fields("time");
$room=$recordSet->fields("room");
$name=$recordSet->fields("name");
$tel_number=$recordSet->fields("tel_number");
$email=$recordSet->fields("email");
$voucher_type=$recordSet->fields("voucher_type");
$voucher_number=$recordSet->fields("voucher_number");
$notes=$recordSet->fields("notes");
//Format the date
$format=("l F jS Y");
$date2 = date($format, strtotime($booking_date));
// PRINT TO SCREEN - table.css
print '
<div class="product_item">
<h4>ID: '.$ff_id.' - Date: '.$date2.' - Time: '.$time.' - Room: '.$room.' - No. of Persons: '.$pax_number.'</font></h4>
<hr />
<h5>Name: '.$name.' - Tel: '.$tel_number.' - Voucher: '.$voucher_type.' - '.$voucher_number.'</font></h5>
<h5>Notes: '.$notes.'</font></h5>
<div style="clear:both"></div>
</div>
';
$recordSet->MoveNext();
}
}
?>
