View Single Post
Old 01-25-2008, 08:22 PM   #12 (permalink)
Village Idiot
Wizard
Top Contributor 
 
Village Idiot's Avatar
 
Join Date: Sep 2007
Posts: 1,299
Thanks: 17
Village Idiot is on a distinguished road
Default

Quote:
Originally Posted by Brook View Post
Thanks all!

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.
__________________

Village Idiot is offline  
Reply With Quote