Newbie Confused. Need guidance. Form data storage on SQL database.

[joebuzz83]

Hi everyone,

I hate being that guy who signs up to a forum and asks a question that's probably been answered 10000 times but I need to. I've searched for an answer tothis question but none that I find make it more clear for me.

I get confused onthe relationships between the webform and how to get the data onto a new database.

My questions are:

is a SQL database something that needs to be made seperatly from a form? In other words does a seperate table need to be set up before data gets sent to a database or can a table be dynamically created from the forms submit button?

After the user submits on a form how does the data get stored? How do I send the data to a database for it o be stored?

I feel like I might get flamed for this, but I hope not. Also I understand that this may not be a 1,2,3 answer, but any guidance that can point me in the right direction would be appreciated.

[mlseim]

A form which appears on the web page, the HTML page is merely a means to allow
someone to type in various text boxes, radio buttons, checkboxes, etc.

When they click "submit", the form variables get sent to a server-side script,
such as a PHP, ASP, or Perl script (or program) that reads those variables and
processes them.

The variables can be stored in a MySQL database, emailed to someone, or whatever.
It's within that script, (most commonly, PHP is used with MySQL) where the data is
processed. PHP opens the database and writes in or updates the necessary data.

There is a lot of online tutorials for PHP, forms, MySQL and putting it all together.
Use Google to find those.