Re: serialize
| From: | Gustav Wiberg | Date: | Sun, 25 Sep 2005 05:01:32 +0000 |
| Subject: | Re: serialize | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223139@lists.php.net to get a copy of this message | ||
----- Original Message ----- From: "blackwater dev" <blackwaterdev@gmail.com>
To: <php-general@lists.php.net>
Sent: Sunday, September 25, 2005 4:17 AM
Subject: [PHP] serialize
I have an app that stores evaluation scores so I have 30+ values all
within a certain range, currently in the db, each of these values has
it's own column:
Table test
id
user_id
motivation
caring
personal_characteristics
creativity,
...etc.
If the client decides they want to trap more characteristics, it
requires changes to the table structure and the table quickly gets
large with 30+ columns. I was thinking of just compacting all of
these down to one column and then using serialize/unserialize and
storing an array of the test scores....is this the best way??
Thanks!
Hi!
It doesn't seem like "good" db-practise to set all the values in one field. You shouldn't be forced to change database-structure just because the user inputs more information.
You may reconsider using several tables and do relations between the tables..
/G
http://www.varupiraten.se/