Ok ... after receiving some great help and education as to how to design a relational database, I went on to try and create the front end for one. I am learning here so bear with me.
To put this into context, so you know, I am using DreamWeaver and Adobe Developer Toolkit to try and create this app. I am not foreign to hand coding and can code PHP to a decent level but I am a bit out of my depth here with this. I want to learn it though so I keep trying ;-)
So I have attached the dB design we had come up with during our previous design sessions, but I decided to simplify it even more ... at least for now while I try and figure out the many-to-many insert thing. So, the second dB diagram is what I am currently using. I have also attached a screen grab of my current form as I thought seeing how this is set up might help you understand what I am trying to do.
So, my issue is that the service checkboxes do not properly get inserted into my userairportservices link table. First, only one of the values gets inserted, I think the last one in the list. What I need to have happen is that if only one service is selected, only one record with the airport_id and the usr_id along with the service_id gets put into the links table. However, if 2 or more services are selected, 2 or more records need to be inserted into the links table while only one user record is to be inserted into the users table. I hope that is clear and perhaps it is obvious to some of you but it is giving me a huge headache.
Perhaps I am way off base here I don't know but the way the form is laid out is the way I would like to have it. Just need to figure out how this is supposed to work
As I am really under the gun here, I am most grateful for any help anyone can give me.