while loop help needed

reub77

I was recently building some php code involving a while loop. The loop looked something like this:

$ch = $_POST['ch'];
$qn = $_POST['qn']; 
$n = 1;

while($n <= $qn):

  $question = $_POST['q"'.$n.'"'];
  $query = "INSERT INTO btwfresults (id, chnum, score, qnum) VALUES ('"'.$userid.'","'.$ch."',"'.$question."',"'.$n'");
//execute query
$result = mysql_query($query);
endwhile;

So, anyways, this didn't work. I hope you can see what I'm trying to do here. Basically this is for a php application I'm building that allows you to read a chapter then take the test at the end. The while loop simply reads the test results question by question. This needs to be reusable, as there are other chapters with varying amounts of questions. Any ideas?

kburger

I'm assuming you have post values coming in like $POST['q1'] $POST['q2'], etc.

Try this

$ch = $_POST['ch'];
$qn = $_POST['qn']; 
$n = 1;

while($n <= $qn):
	$question = $_POST["q$n"];
	$query = "INSERT INTO btwfresults (id, chnum, score, qnum) VALUES ('$userid','$ch','$question','$n')";
	//execute query
	$result = mysql_query($query);
	$n++;
endwhile;

reub77

Nope tried that too, for some reason it didn't like me throwing a variable into the post method.

xblue

Hi, do I get it right that the data is coming from a form with n being a (variable) number of questions named q1, q2, ..., qn?

If so, you might think about changing the form so that the names are q[0], q[1], ..., q[n-1], or even easier name them all q[] - either way, the data would arrive as array then, which is easier to handle, something like

while($n < count($_POST['q'])): 
    $question = $_POST['q'][$n]; 
    // ...
    $n++;
}

reub77

Thanks your code helped!