mcolton

Thanks for your help. Like I said, I have it working but I'll look to update it

Just an update. I moved the "insert into" to newregistration2.php where I know all the fields are correct.I got it to work correctly.Do you still think I should rewrite the whole thing.Is there a good online tutorial for new code I should be using?Thanks for all your help

Sorry but I'm even more confused now. Let me make sure you know what the intention of the code is.A user puts in his first and last name (in a previous file). I look to find an existing record in the db with those names.If it finds one, they are told that they have already have entered their data (already-registered.htm line 15).If not, I create a new record and insert the values from the html script.eg: line 183 they input their email address (field name = xemail).I know the values are moving onto "newregistration2.php" (line 172) because that program sends out an email and I'm gettingan email with the correct field data. (I've attached that program this time) Maybe I should move the "insert into" to newregistration2.php where I know all the fields are correct.Or do you think I should rewrite the whole thing.Is there a good online tutorial for new code I should be using?Thanks for all your help newregistration2.php

I inherited it. I'm not a sql programmer. I do program html.I think the variables are defined in the "registrationform" in the html script below the php code.I know some of it is working because "newregistration2.php" is working (line 172).Thanks for replying

I'm having trouble with the attached code. I'm not getting any error messages and the code is progressing to the next step correctly. It's just not creating a new record in the table. Thanks for any help trynewregistration.php