Search the Community
Showing results for tags 'joins sessions'.
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