Assigning a variable before write to MySQL

RickL66

I'm trying to multiply $total before I write to the database...$total is always the number of tickets times 25 ($25 per ticket) plus any donations this is what I have:

<?php
if ($submit) {
        {$total = $tix*25+$donation}
	{
   		$sql = "INSERT INTO vday (name,address,city,state,zip,email,vp,day,tix,donation,total,ccname,ccnum,ccmonth,ccyear,cctype,notes,entered) VALUES ('$name','$address','$city','$state','$zip','$email','$vp','$day','$tix','$donation','$total','$ccname','$ccnum','$ccmonth','$ccyear','$cctype','$notes', '0')";
		$result = mysql_query($sql);	
	}
?>

but I'm getting an error at the line '{$total = $tix*25+$donation}' - I checked my syntax and it looks right. :bemused:

Piranha

Two things:

First, what happens if the price changes in the future? Then you need to go through all the code and change it everywhere. You are way better off with using a variable instead, that variable could for example be in an included file on in the SQL database.

Second, I think that using semicolons in the end of the lines is a good idea. It would at least solve your problem.

RickL66

Piranha wrote:
Two things:

First, what happens if the price changes in the future? Then you need to go through all the code and change it everywhere. You are way better off with using a variable instead, that variable could for example be in an included file on in the SQL database.

Second, I think that using semicolons in the end of the lines is a good idea. It would at least solve your problem.

Ah! Semicolons. I always forget those. As for the price change - it is a one time thing and the event is happening in February. After the event, basically, I just throw away my code.

andrew_1st_DNS

Ahhh, Had a similar problem. Thanks Piranha . One day i am sure it will all click.