Comparing and adding DB fields

[quilldj]

Hello all,

I am trying to create a script that will allow me to compare all of the fields in a database with user input.

I have created a form that dynamically creates fields to be entered into a MySQL DB. The thing I am trying to do when the form is submitted is to check to see if all of the fields currently exist and if they do not than I would like to be able to add that field dynamically from the form. I know how to create the field in the DB and insert data just cannot figure out how to extract and chech existance of field names.

Am I making any sense? Forgive me as I am fairly new to programming in general.

I appreciate any help and thanks in advance.

[MrCool]

Originally posted by quilldj
check to see if all of the fields currently exist

You mean they are not empty?
If that's it then use: empty(string) and a if condition.Or use javascript to check if the form was well filled

[quilldj]

Originally posted by MrCool
You mean they are not empty?
If that's it then use: empty(string) and a if condition.Or use javascript to check if the form was well filled

Sorry, let me try to carify that.

If I have a table named "table1" with 3 fields (columns) called "column1", "column2", "column3" and the user submits my for form with 4 fields/columns called "column1", "column2", "column3", "column4" how do I check to see if column4 exists in the "table1" and if it does not to add the field/column and then input the data relative to the new field/column.

Does that make more sense? It is hard to explain.

Thanks.