insert values

[gple]

I have a bunch of information that I want to insert into a table

 

insert into TABLE values ('hello','I','am','lost');

 

pretend that the words that are being inserted are coming from a form for another page. In he case I above I have declared that the table has four columns to insert into. What if I do not know how many columns there are?

[Jessica]

If you don't know how many columns are in your table, you have not designed your database well.

[gple]

This is what the situation is: I am building a page that reads how many columns are in a table. Depending on how many columns,  a form is created to input data into each of those columns. Then I pass the data to another page which inserts it into the table. But the question is this:

 

I need to create an insert statement dynamically depending on how many columns there are.