I have a form that adds records to a table. There are approximately 200 fields in the table. Using a regular 'Insert' command in an html/php form has been less than reliable when requesting and Insert of 200 values into their respective fields.
I am wondering what the best alternative is to do this. I thought if issuing multiple Insert commands, but then I thought that somehow I could use the 'Load Data Infile' command. Is there a way to write the values to a file/variable and then call up the variable when issuing the 'Load Data Infile' command in the form?
I am pretty new to this and feel satisfied that I even have my basic add form working.
