Anyone see something wrong here : My error message is : "0: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ddddd',1,'ddddddddd',1,1, 31, 33,10/15/2004))' at line 5" Code: $query = "INSERT INTO MainTable (RecordID,UserID,other fields..............) values (null,null,'$f1a',$f2a,$f2c,$f2d,$f2e,$f2g,'$f5b','$f3m','$f3n,'$f3e',$f3f,'$f3g',$f3h,$f3i, $f3j, $f3k,$f3l))"; //not sure if the double ) is //needed though it doesn't make a diff begin(); // transaction begins $result = mysql_query($query); --- Stuart Felenstein <stuart4m@xxxxxxxxx> wrote: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php