I have just finished Chapter 9, to get a feel for were I'm at in my reading.
Chapter 6 (Advanced SQL and MySQL) does an excellent job of explaining database design and relating tables through primary and foreign keys. I understand how to SELECT columns from multiple tables using table JOINS.
Ok, my question is:
How do you INSERT data across multiple tables? When working with forms, should forms correspond to one table at a time?
Say the form has name, email fields that corresponds to the users table. And then the same form also has address fields that correspond to the location table.
I might of been getting ahead of myself here as Chapter 11 explains how to track users through sessions, I have skimmed the chapter a little as I've become very curious. I don't know to much about sessions at this point. Is sessions the practical most widely used method for accomplishing this?
Thanks,
Mark