I am building a site where people can post items for sale in different groups (Clubs, organizations, etc). On the main page they will search for their group and when they select it, it will take them to the group portal which displays the items specifically posted to that group. If their group isn't there, then they can add it.
I am pretty new to MySQL. All i could think of doing for when people add their group is...
1. Create a table for the groups info and assign the name, id, etc.
2. Automatically create a new table called group[id]. I then can get the ID from querying the NAME and then access the group[id] table with posts. This way of doing it is extremely limited and cluttery... My database is looking like