// I always explicitly define my columns during inserts. That way, if my table structure changes the insert will still work. // note that I don't insert into the 'id' column as the db should figure that out. // Still a bit funky, and hope you don't mind the formatting but it's a lot of vars to keep track of... -D $query = "insert into kf_webform_test (date, creation_date, date, registered, activated, paid, firstname, lastname, busname, address, city, zip, dayphone, evephone, email, fax, standardrate, paypaltransactionid, checkno, moneyorder, t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, stotal1, stotal2, stotal3, stotal4, stotal5, stotal6, stotal7, stotal8, stotal9, stotal10, stotal11, stotal12, registeramnt, stateprovince, shirttotale, subtotal, totalaz, total, twhite, roommate, smoker, active, ethernet, inform, listemail, intck, intdate, intxctn, aztaxrate, applicantsignature, specreq values ( '$frmtmp01', '$frmtmp01a', '$frmtmp01b', '$frmtmp01c', '$frmtmp01d', '$frmtmp01e', '$frmtmp02', '$frmtmp03', '$frmtmp04', '$frmtmp05', '$frmtmp06', '$frmtmp07', '$frmtmp08', '$frmtmp09', '$frmtmp10', '$frmtmp11', '$frmtmp12', '$frmtmp13', '$frmtmp14', '$frmtmp15', '$frmtmp16', '$frmtmp17', '$frmtmp18', '$frmtmp19', '$frmtmp20', '$frmtmp21', '$frmtmp22', '$frmtmp23', '$frmtmp24', '$frmtmp25', '$frmtmp26', '$frmtmp27', '$frmtmp28', '$frmtmp29', '$frmtmp30', '$frmtmp31', '$frmtmp32', '$frmtmp33', '$frmtmp34', '$frmtmp35', '$frmtmp36', '$frmtmp37', '$frmtmp38', '$frmtmp39', '$frmtmp40', '$frmtmp41', '$frmtmp42', '$frmtmp43', '$frmtmp44', '$frmtmp45', '$frmtmp46', '$frmtmp47', '$frmtmp48', '$frmtmp49', '$frmtmp50', '$frmtmp51', '$frmtmp52', '$frmtmp53', '$frmtmp54', '$frmtmp55', '$frmtmp56', '$frmtmp57', '$frmtmp58')";