help with SUM()

[nic.lk]

I'm creating something small for reps to follow up on sales.

can somebody help me out with this

Quote:
$com = SUM($amount*0.25);

$qry = "INSERT INTO data (date, rep, client, amount, com, status) VALUES ('$postdate', '$rep', '$client', '$amount', '$com', 'pending')";
$result = mysql_query($qry);
if($result) {
header("location: success.php");
exit();
}else {
die("Query failed");
}
the problem is $com commision on sales.

_________________
Blue shield home insurance bedroom furniture

[wcsupport]

Hi,

Note really sure what the problem you are having is.

Might be best to remove the multiplkication from inside the ():

$com = SUM($amount)*0.25;

Thanks

[suman]

I would write it like this:

$com=$amount*0.25;

instead of:

$com=SUM($amount*0.25);

I just never use the sum personally, but it doesn't look like it's a problem.

effectively, you're trying to divide the price by 4? or 25% of the actual price?

Maybe explain more and I might be able to help