Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-18 Thread Niel Archer
Ok, so getting closer to the goal.. slight hiccup. I am experimenting with some UNION and INNER JOIN and don't know if I am doing this correctly or if this is the correct way to do this. PREFACE: I have now moved colors and sizes to their own tables and added a product options table

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-18 Thread Karl DeSaulniers
Hi Niel, Thanks for taking the time to respond. Comments below. On Jan 18, 2012, at 11:14 AM, Niel Archer wrote: Ok, so getting closer to the goal.. slight hiccup. I am experimenting with some UNION and INNER JOIN and don't know if I am doing this correctly or if this is the correct way to do

[PHP-DB] Multiple Access to Database - The Answer

2012-01-18 Thread Ethan Rosenberg
Dear List - I have a database: mysql show tables; +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql describe Intake3; ++-+--+-+-+---+ | Field | Type