A Simple Math Function !?

bart

or so I thought!

Can anyone tell the correct syntax for the following?

php:

$row = mysql_fetch_row($check_result);

        $current_ticket_total = $row[11];

        $new_ticket_total = $confirm_tickets + $current_ticket_total;

Basically, the $confirm_tickets is generated from a form, then the email address is validated in the database, and the total number of tickets they have ordered previously, should be added to the $confirm_tickets and the row in the database updated.
However, the $confirm_tickets total is always used and replaces the $new_ticket_total in the database so both columns display the same!

tomhath

Ummm, why don't you use $new_ticket_total to update the database?

Or get rid of the extra two variables and keep the number of tickets in $confirm_tickets:

$row = mysql_fetch_row($check_result); 
$confirm_tickets += $row[11];

MrAlaska

So what made you choose this particular snippet to blame it all on? Are the values getting populated?

<?php
// first line of code on page
error_reporting(E_ALL);


$row = mysql_fetch_row($check_result); 

$current_ticket_total = $row[11]; 
echo "<br>CURRENT TICKET TOTAL: ". $current_ticket_total;

$new_ticket_total = $confirm_tickets + $current_ticket_total; 
echo "<br>CONFIRM TICKETS: ".$confirm_tickets;
echo "<br>NEW TICKET TOTAL: ".$new_ticket_total;
?>