rendered paste body// 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')";