So embarrassed to be here for this again...
So I finally finished my final form and it looks great, the dynamic dropdowns work awesome. Now I decide to test the functionality; you know, see if it adds the record. At first it failed and I thought it happened because I didn't log in setting the session Id that's needed to identify the client.
So now I go and start the registration process since I removed the database and replaced with a slightly altered one (this erased all the records in the specific tables). But now the registration form doesn't work. It gives me the same error I was getting originally when I was doing it with FB.
Cannot add or update a child row: a foreign key constraint fails (`zonapromo/Clients`, CONSTRAINT `fk_Clients_country_t1` FOREIGN KEY (`country_t_country_id`) REFERENCES `country_t` (`country_id`) ON DELETE NO ACTION ON UPDATE NO ACTION) 
I then proceeded to redo the registration form and still no dice. I tested the table by inserting the record via phpmyadmin and that worked. So I figure I can test the projects form with that record. So I log in...that worked great and then I fill in my info for the project... everything looking good, so I send. I get the same problem jason solved for me initially. Si come here and look for the solution he gave and re-apply it (it was still set the way I had it to begin with, but for reassurance, you know?) but that didn't do the trick for me.
So, to summarize, the registration form does not register :confused: (pun intended) and the new project form once again stays in limbo. I'm not sure if all that turkey stuffing filled my brain with dumbitis, but I'm hoping the files I have uploaded will give you some insight on where I'm going wrong. I even included the .sql file I'm using for the database in case it helps.
I know these things can get confused sometimes with changes, but I don't get how a simple changes to the table (All I did was remove the location column in the client table and replaced it with the country Id foreign key) would cause it to stop working like this, I did rebuild it. Hoping you will shed some light on the matter.
jc
