Umm_Hasan - 3:54 pm on Mar 10, 2011 (gmt 0)
makue........thanks for the reply. I did read throught that post you directed me to; however, that is not the case in my problem. This would be the case if the field is empy (not selected) but in my case, every field including my select box is filled out and/or selected/and or checked. Actually, all of the fields in my form are required and I am the one completing the form since its not live yet. I am in the testing phase before the form goes live. And I have done at least 20 runs of the form and every time, being SURE all Post values are completed, I have the same problem - the extra empty row BEFORE the complete data row.
As for the error i'm getting, it seems that it may be related to the fact that I am writing the value taken from the last querty to the forign key field via mysql_insert_id();
but, I am not sure thats the problem. I will comment that out and see if the error goes away.........but I still need to solve the extra empty row problem even if that gets rid of the error. Why? Because this database is assigning registration numbers (the ID fields) to participants in a competition and their numbers will be printed on thier name tags during competition testing and the finalist competition day and we dont want to have several numbers skipped out on because of these extra rows or we will get multiple blank lables once the info is exported to a csv file and used to print the lables.
Any more help would be appreciated!