djfox

Maybe I need to reword my question: What is LEFT JOIN doing?

What is the LEFT JOIN stuff?

I`ve already long since got the database stuff, now it`s the code I need. I`ve looked over the code you provided but I am not getting it. I`ve been trying to explain many times that I`m not understanding what it is being said and I`m not seeing how this can be done in one form, and yet the database structure keeps getting brought up, but that isn`t helping me understand how the code is going to get done. I can`t spend money to have someone else do it, I`m poor, or else I would`ve just hired someone else to do it for me and would`ve skipped all this (I`m not getting paid to have this code done anyhow).

So anyone going to give me a hand with the code?

Are you testing this script off your harddrive or do you have it uploaded onto a server?

No see, we -want- that history. That`s why I was trying to get this stuff entered into the database in the first place. The thing is to get the pets and services selected and chosen in one form, which will automatically create the history and the invoice would be built from that, rather than making copy A into history and copy B in invoice. What I wanna do is get it all done with just the one form. I can get the pets from the one customer to show up. I can get the list of services to show up. What I can`t do, is get all that to enter into the database with that one click of the submit button.

@ChemicalBliss My lack of being able to understand continues. For each service that has to be done with each pet, a new entry has to be made into the whatever database table? Wouldn`t this mean that still a form has to be entered for each service for each pet? I`m not seeing how in a list of pets each with a list of services could be done in one form.

I`ve looked it over but I don`t see how that could possibly be done in one form. I can only see it being done with multiple forms.

Yep, that`s the proper way to help me understand things... I`m having an extremely difficult time understanding what it is that you guys are trying to tell me to do. All I can get out is that more tables have to be made and the clerk has to fill out multiple forms. That`s all that I`m getting from here.

What? I don`t know what that is or how to do it. Haven`t a clue of what that is either. Ok but wouldn`t this still require the clerk to sit there and fill out form after form after form just for one single client to do EACH job for a pet, and then do it all over again for their second pet, etc?

Why? What do I need it for? What does that do? What kind do I go for? I`ve searched on this and all I`m finding are sources on books to buy, I can`t find anything online. Now I`m getting frustrated about trying to get this project done and no one here is making any sense or providing anything that is actually being helpful.

Sorry to say that I haven`t a single clue of what it is you`re trying to explain to me to do. I`ve read over that post 6 times, read over your second post twice, I am not getting it at all.

@Thorpe: Your post tells me nothing. @ChemicalBliss: Wait wait wait, are you telling me that the best way to do this is to have the clerk go through and do something like: Create an invoice Select Owner 1 Select Pet A Select Service A Create an invoice Select Owner 1 Select Pet A Select Service B Create an invoice Select Owner 1 Select Pet A Select Service C Create an invoice Select Owner 1 Select Pet B Select Service A Etc etc etc? That`s ridiculous! Not to mention VERY inefficient for a business! Vet offices and other professional places do not do this. Second of all, you`re telling me to rebuild my owner and pets tables and rebuild how the owners pets are id`ed to the owner? Why? My system of bringing up the owner`s pets are working just fine. Unless I have TOTALLY misunderstood everything you`ve written...Which is quite possible.

Ok, this line: $sql="UPDATE players SET displayname = '$displayname', campname = '$campname', WHERE id='$id'"; Change it to: $sql="UPDATE players SET displayname = '$displayname', campname = '$campname' WHERE id='$id'"; You have an extra comma that shouldn`t be there.

I don`t see anywhere in your code that $displayname $campname and $id are picked up on for the system. You would need to add in $displayname = $_GET['displayname']; $campname = $_GET['campname']; $id = $_GET['id']; If you`re using post method for the form on the previous page, then replace GET with POST. Without specifying those before you tell the system to add them in, the system won`t know what it`s supposed to grab.