Basic Form Help Needed

BulldogGC

I'm not even sure if it's the correct tag I want to be using.
Anyway ...

I have a form that is dynamically generated ...
Say I choose to have 3 answers it will generate 3 input text fields named "form_answer1" through "form_answer3"

And what I want to do is insert this into a database.
But I can't get it to work ... here's the code I'm trying:

$i = 0;
    while($i < $count) {
        $answer_content = eval("form_answer" &  $i);
            $sql_insert = "INSERT INTO polla (pollid,answer) VALUES ('$pid','$answer_content')";
            $execute_insert = mysql_query($sql_insert);
                $i++;
    }

Basically I'm trying to dynamically generate whatever was inputted into the "form_answerWHATEVERNUMBER"

douceur

You could try something of this manner:

foreach ($_POST as $value) {
  mysql_query("INSERT INTO polla (`answer`) VALUES ('$value')");
}

And you could just make pollid auto increment. Not sure if that's what you meant, though.

BulldogGC

No, sadly it's not.
Let me try to explain it again --

I have a randomly generated number of input forms (not really randomly ... but play along)

One time it might be

form_answer1
form_answer2

But sometimes it might go all the way up to form_answer20

douceur

Are there any values submitted with the form other than the form_answer values?

BulldogGC

No form variables.

You go ... Submit Question & How many answers you want.
It then runs the query to submit the quesion and creates the correct number of input fields for the answers.
Then you hit step 2 and it's supposed to add those answers.

There are URL variables ... "count" which is how many input fields there are in total and the others don't matter (eg. "s=2" for step 2, etc.)

douceur

for ($i = 0; $i < $count; $i++) {
  $answer_content = 'form_answer ' . $i;
  $sql = "INSERT INTO polla (`pollid`, `answer`) VALUES ('$pid', '$answer_content')";
  $result = mysql_query($sql);
}

BulldogGC

Beautiful!! Thanks!

douceur

Anytime.

BulldogGC

Actually didn't work.
It's constructing it correctly and properly.

But it's not recognizing it as actual FORM data rather just the static text "form_answer1", etc.

douceur

for ($i = 0; $i < $count; $i++) {
  $answer_content = 'form_answer' . $i;
  $sql = "INSERT INTO polla (`pollid`, `answer`) VALUES ('$pid', '{$_POST[$answer_content]}')";
  $result = mysql_query($sql);
}