[SOLVED] Simple Math from Form Question

[tgreene]

Hello all.. long time lurker, first time poster 

 

I'm trying to setup some simple math to happen after a form submission occurs.

Here a snippet of the current code MySQL submit code:

<?php
$con = mysql_connect("localhost", "xxx", "xxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("db", $con); $sql="INSERT INTO ATS2007 (value1, value2, value3) VALUES ('$_POST[value1]','$_POST[value2]','$_POST[value3]'" ;if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

 

Essentially what I want it to do is this - > (Value2 - Value1) and then store it at Value4.

 

Is this something that I do in the form action code (as show above) or in the form itself?

 

Many thanks in advance!

[MadTechie]

something like this ?

 

<?php
$con = mysql_connect("localhost", "xxx", "xxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
$value4 = ($_POST['value2'] - $_POST['value3']);
mysql_select_db("db", $con); $sql="INSERT INTO ATS2007 (value1, value2, value3, value4) VALUES ('{$_POST['value1']}','{$_POST['value2']}','{$_POST['value3']}','$value4'" ;if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

 

of course you could use

('{$_POST['value1']}','{$_POST['value2']}','{$_POST['value3']}','($_POST['value2'] - $_POST['value3'])'"

 

but the 1st one it easier for debugging

[tgreene]

Wow, that was easy!

 

Thanks so much for the quick reply.. got it working already!

[MadTechie]

cool, can you please click solved to save others opening this thread to help then find its already resolved

 

solved is bottom left