I'm working with MariaDB through PHPMyAdmin and I have a question about how I need to set up my database. For eash person in the table I am currently building I'll also need an array of date values. I don't think there is a way for me to setup a table in this fassion.
-> fName, lName, ID, arrayOfDateValues. I will also not know exactly how many date values may be needed, sometimes an entry may only need 1, other times and entry may have 4+. I'm assuming I'll need to create a sepearte table and just make sure that I create enough rows for all the possible dates I may need. Could someone shed a llittle light on this for me please? Thanks.
Also, does anyone know how to create a key table PHPMyAdmin so I'll be able to link up the date(s) with the correcty entries? Thanks again.