Hey I am trying to do a thing that lets users sign up for info about different topics and stuff, and I want them to be able to click a button to get their name on a list. Like a facebook group. I also need to be able to find individual users from these lists (using the mysql select from table where...)
How can this be done?
storing list in cell of a mysql table
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
It seems to me a separate table would be a little more than i need....
To be more specific on what I want:
Each user will be able to post a bit about whats going on with him. People will be able to click to put their name on a list so that he email an update to all those people when something changes.
Maybe I'm wrong, but why would I need a table for that? Heres what my userdata table looks like
Userid | Username | Password | Email | Subscribers
is it not possible to store a list (array?) in the subscribers cell?
To be more specific on what I want:
Each user will be able to post a bit about whats going on with him. People will be able to click to put their name on a list so that he email an update to all those people when something changes.
Maybe I'm wrong, but why would I need a table for that? Heres what my userdata table looks like
Userid | Username | Password | Email | Subscribers
is it not possible to store a list (array?) in the subscribers cell?
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
The major problems with a solution where the data is stored in a single record are searching and capacity. You will have a finite number of references the field may hold. As the reference numbers reach higher numbers of digits you will accordingly shrink the number of possible references a user may have. Do you find that fair to those users? No. Searching this data and thereby altering it will become far more of a nightmare than a normalized table solution.