Creating tables with while statement?

[Anon]

Quick question. I have a form that a person fills out. One is how many questions do you want to create?

They insert a number and click submit. The next page shows the question fields up to the number they selected like 6.

I want them to fill out those questions and click submit. From there it creates the table and the number of fields according to the number of questions. So if they chose 6 questions then 6 fields would be created.

How would you go about doing it? I can only get one field in.

$sql"CREATE TABLE test";
while ($i < $questioncount) {

++$i;
$sql .="(question_$i varchar(100))";

}

but when I do this I only get question1 as the field name. nothing more, nothing less.

[tomhath]

Look at the string you are building. I'm surprised you even get the first field. Mkae the field a comma delimited list with only one pair of enclosing parenthesis instead of this:

CREATE TABLE test (question_1 varchar(100))(question_2 varchar(100))(question_3 varchar(100))

[Anon]

Ahh. Woops forgot to tell ya I fixed this like 10 minutes after I posted.

Sorry. Thanks for the info though!