Adding data - more than one piece in a column?
View Single Post
01-25-2008, 08:22 PM
Join Date: Sep 2007
Originally Posted by
Yes the relations table makes sense (I don't think I have seen it mentioned before).
I guess I can still have an input field where the person creating the page puts the actor ids seperated by comma and then use the
$seperated = explode(',', '124,366,697,125,123');
to create an array which is then used to enter the actor ids into the relations table (?).
Is there any time when I should skip the relations table and just use the 'explode' method?
What if I simply want to add 'related actors' to a news item or a feature - would the relations table be overkill?
There is never a good time to store data like that. Its simply bad database design.
View Public Profile
Send a private message to Village Idiot
Find More Posts by Village Idiot