Multiplication of a variable - then entry into a table.

[topshelfbleu]

Hi

The page I'm working on will receive a value from a radio button ( '$q1' and then I need to apply 3 seperate multiplications to it. The 3 values will then be placed into a table.

 

How do I turn the values into named variables which then can get placed into the dbase using the insert into dbasename  and values

 

So far I've done this

 

<?php

$con = mysql_connect("blah","blah","blah");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("candango", $con);

 

$q1 =$_POST['q1'];

$multiplication = '$q1'*3;

$multiplication = '$q1'*5;

$multiplication = '$q1'*10;

 

 

$enter_sql= "INSERT INTO answers (answer from 1, answer from 2, answer 3)

 

$enter_query =mysql_query($enter_sql) or die (mysql_error());

?>

[/code]

 

Any guidance - greatly accepted! 

 

Thanks

 

Nick

[DavidAM]

Just assign them to separate variables:

$answer1 = $q1 * 3;
$answer2 = $q1 * 5;
$answer3 = $q1 * 10;


$enter_sql= "INSERT INTO answers ($answer1, $answer2, $answer3)";