$submit = $_POST['submit'];
if ($submit)
{
mysql_connect("localhost","mmaaaco_ksecor","hamilton");
mysql_select_db("mmaaaco_ksecor");
$question = $_POST['question'];
$sql = mysql_query("insert into 3312questions (question) values ('$question')");
echo "insert into 3312questions (question) values ('$question')";
if($sql)
{
$qid = mysql_insert_id();
foreach ($_POST as $key => $value)
{
echo "$key $value
";
if (ereg("right",$key))
{
$innersql = mysql_query("insert into 3312canswer (questionid,answer) values ('$qid','$value')");
echo "insert into 3312canswer (questionid,answer) values ('$qid','$value')";
if (!$innersql) echo mysql_error();
}
if (ereg("wrong",$key))
{
mysql_query("insert into 3312wanswers (questionid,answer) values ('$qid','$value')");
echo "insert into 3312wanswers (questionid,answer) values ('$qid','$value')";
}
}
}
}
?>