For you php (just good practice that may be causing some issues) try making sure that you call to arrays with some sort of quotes around them:
QUOTE
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("radio", $con);
$sql="INSERT INTO radio (q1, q2)
VALUES
('" . $_POST['question1'] . "','" . $_POST['question2'] . "')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "your quiz is submitted";
mysql_close($con);
?>
Also look into the website security tutorial if you have the time, it could save you a lot of hard work if someone was to inject malicious content into your queries.
http://www.dreamincode.net/forums/showtopic54760.htm (has a little on it, but is not all about injection protection)
Also, in your form you probably have radio buttons, what you need to do is name each radio button for each question the same thing (liek
question1), that is the name you are calling in the $_POST['
question1'].
So your form should look something like so:
CODE
<form name="form1" action="" method="post">
Q1: What is 1+1?
<input type="radio" name="question1" value="2">2
<input type="radio" name="question1" value="11">11
<input type="radio" name="question1" value="1">1
<input type="radio" name="question1" value="0">0
and so forth
</form>
Than, to gett the auto submit working with your countdown code you just do something liek so:
QUOTE
<script type="text/javascript">
var days = <?php echo $remainingDay; ?>
var hours = <?php echo $remainingHour; ?>
var minutes = <?php echo $remainingMinutes; ?>
var seconds = <?php echo $remainingSeconds; ?>
function setCountDown ()
{
seconds--;
if (seconds < 0){
minutes--;
seconds = 59
}
if (minutes < 0){
hours--;
minutes = 59
}
if (hours < 0){
days--;
hours = 23
}
document.getElementById("remain").innerHTML = days+" days, "+hours+" hours, "+minutes+" minutes, "+seconds+" seconds";
SD=window.setTimeout( "setCountDown()", 1000 );
if (minutes == '00' && seconds == '00') { seconds = "00"; window.clearTimeout(SD);
//window.alert("Time is up. Press OK to continue."); // change timeout message as required
//window.location = "http://www.lucknowmail.com" // Add your redirect url
SubmitForm();
}
}
function SubmitForm() {
document.form1.action = "insert.php";
document.form1.submit()
}
function ResetForm() {
document.form1.reset()
}
</script>
Hope that helps.