I do apologize for the uninspired title, I'm not sure how best to put it.
Another person helped me massively in another question I posted regarding the structuring of data.
The solution has left me with another bit of a brain ache. I will paste some of that users response to me as it reflects what I currently have, I do apologize if that is poor etiquette.
Basically I'm allowing users to store a certain amount of text information each day, for example, 7 entries daily. Entries referenced as things.
The current structure works as follows (
UID is Users ID + Date):
Things PK PK UID thing_id thing 71420150404 0000001 First thing 71420150404 0000002 Second thing
The user that helped me before came up with the following way to enter data:
INSERT INTO test.Things(UID,thing_id,thing,thing_date) SELECT :uid, MAX(IFNULL(thing_id,0))+1, :thing1, NOW() FROM test.Things WHERE UID=:uid ON DUPLICATE KEY UPDATE thing=:thing1,thing_date=NOW();
This works perfectly, however the problem is only one entry can be added at a time. A workaround I've found is to take all the entries (things) as an array in my PHP and execute the SQL statement over and over for each entry. This seems highly inefficient.
Though I have been getting the basics of SQL through online courses I haven't been able to work out how to a better solution to this through SQL itself.