No, use another table, poll_options: poll_option_id, poll_id, option_text, vote_count
hope the structure is self explanatory.
Sævar Öfjörð wrote:
Hi. I’m coding a poll system which stores information in MySQL.
When a new poll is created a new row is inserted in the table ‘polls’. There I keep basic information such as the question, id etc. But should I keep the poll options in one field also? Then I would create an array from the poll options the user specifies, serialize it and then base64_encode it.
Is this a good way of storing an array or should I make a database table named for example: ‘polls_options’?
Any opinions and thougts on this appreciated.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
