Re: Re: Large forms to Mysql table...

At 10:33 PM 8/14/2005, mikespook wrote:

Like this: $str = print_r($_POST, true); then insert $str into db. It`s easy way~~right? ""Andras Kende"" <andras@kende.com> ??????:CE.18.33075.AECAEF24@pb1.pair.com... Hello, I have a html page with 70+ form fields some like 40 fields are only used for entering quantity numbers… Is it a good idea to put this 50 fields of the form fields into a single text mysql field? Somehow process it with php before, put inside of some kind of xml structure? Just don’t want to do Mysql table with 70 fields…

One of the advantages of relational databases is that you do not have to know the structure of the data. Why break that? Why subject yourself, and the developer who follows you and has to maintain your code, to parsing hell? Why do you not want to do a MySQL table with 70 fields? MySQL is designed for this sort of thing. Given the tone of these comments, your database design may be questionable. Is a lot of data in a given table redundant; and if so the design likely needs work. Regards - Miles Thompson