Alright everybody! Here's a whopper for you. I've looked over this for the longest time and just can't figure it out. I want to update my database with the user's information when they save the html form. I'm guessing there's like a quotation mark or comma misplaced or something, and I've just had too much happy-juice, but... anyway, it works if I take out all the variables after "hs_prnt1". The SELECT query works all the time. It just won't UPDATE if I put the rest of those variables back in. Is the server at a query limit or something? Those tables, when put together, do obviously have a lot of rows in them... like 150 altogether. Please don't hate, but I'm gonna post the whole code here, since it may be necessary to figure this one out. I put some markers next to the variables that gives me problems. Here it is:
Did you tried to print_r($_POST); at very top of the file to check if everyting you need is retrieved?
Second: add or die(mysql_error()); at the end of the update query, line 351 and check what happens, bye.
Nevermind, I see it. I think you should probably make another file, and start off with a smaller amount of code to figure out your issue and then start adding in more code. The bigger it is, the harder it is to troubleshoot.