While building a site I came across the following issue:
I want to be able to have multiple containers and within each container have ids pointing to multiple items that lie on another table. Scheme:
I am using MySQL and would like to stick with it. However I am open to other ideas.
My questions are:
- Would this be a reasonable data structure, or is there any better way to organize this data?
- If So, How would I go about implementing this idea of "array of pointers" to elements.
Possible Solution: http://tutsbook.com/mysql-foreign-keys/