One to many too much data returned - MySQL
- by Evan McPeters
I have 2 related MySQL tables in a one to many relationship.
Customers: cust_id, cust_name, cust_notes
Orders: order_id, cust_id, order_comments
So, if I do a standard join to get all customers and their orders via PHP, I return something like:
Jack Black, jack's notes, comments about jack's 1st order
Jack Black, jack's notes, comments about…