topshelfbleu Posted October 5, 2010 Share Posted October 5, 2010 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 Link to comment https://forums.phpfreaks.com/topic/215207-multiplication-of-a-variable-then-entry-into-a-table/ Share on other sites More sharing options...
DavidAM Posted October 5, 2010 Share Posted October 5, 2010 Just assign them to separate variables: $answer1 = $q1 * 3; $answer2 = $q1 * 5; $answer3 = $q1 * 10; $enter_sql= "INSERT INTO answers ($answer1, $answer2, $answer3)"; Link to comment https://forums.phpfreaks.com/topic/215207-multiplication-of-a-variable-then-entry-into-a-table/#findComment-1119286 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.