From: Peter Brawley Date: August 14 2005 5:27am Subject: Re: spatial extensions - SRID List-Archive: http://lists.mysql.com/mysql/187795 Message-Id: <42FED65D.6050201@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-42FED65E5E3E=======" --=======AVGMAIL-42FED65E5E3E======= Content-Type: multipart/alternative; boundary=------------080708030207090901060005 --------------080708030207090901060005 Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 8bit Andras, />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? / Nothing wrong with 70 columns unless there are interdependencies &/or groupings amongst the 70 values that require normalisation. Definitely, 70 numeric columns would be a much better idea than one text column with 70 numeric values embedded in it! Sounds as if you need to read a bit about normalisation. PB ----- Andras Kende wrote: >Hello, > >I have a html page with 70+ form fields some like 40 fields are only used >for entering quantity numbers… > >Don’t want to do Mysql table with 70 fields… > >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? > >Thanks, > > >Andras Kende >http://www.kende.com > > > > --------------080708030207090901060005 Content-Type: text/html; charset=windows-1250 Content-Transfer-Encoding: 8bit Andras,

>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?
Nothing wrong with 70 columns unless there are interdependencies &/or groupings amongst the 70 values that require normalisation. Definitely, 70 numeric columns would be a much better idea than one text column with 70 numeric values embedded in it! Sounds as if you need to read a bit about normalisation.

PB

-----

Andras Kende wrote: 
Hello,

I have a html page with 70+ form fields some like 40 fields are only used
for entering quantity numbers…

Don’t want to do Mysql table with 70 fields…

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?

Thanks,


Andras Kende
http://www.kende.com
--------------080708030207090901060005-- --=======AVGMAIL-42FED65E5E3E======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/2005 --=======AVGMAIL-42FED65E5E3E=======--