mySQL Error: Column count doesn't match value count at row 1
I count 60 columns and values for the insert. Must I insert every column in the DB? I am going nuts with this, it all worked fine last year, all I added was the "times" and "lessons" to the insert to accommodate more options.
What am I doing wrong?
Code: Select all
mysql_query ("INSERT INTO campers
(first_name,
last_name,
password,
email,
age,
dob_1,
dob_2,
dob_3,
s_address,
s_city,
s_state,
s_zip,
m_address,
m_city,
m_state,
m_zip,
mom_name,
m_home_phone,
m_summer_phone,
m_work_phone,
m_cell_phone,
dad_name,
d_home_phone,
d_summer_phone,
d_work_phone,
d_cell_phone,
staying_name,
staying_relation,
staying_address,
staying_city,
staying_state,
staying_zip,
staying_phone,
pickup_name1,
pickup_relation1,
pickup_name2,
pickup_relation2,
pickup_name3,
pickup_relation3,
med_problem,
med_explanation,
meds,
allergies,
doctor,
doctor_phone,
dentist,
dentist_phone,
insurance,
ins_id,
em_1_name,
em_1_relation,
em_1_phone,
em_2_name,
em_2_relation,
em_2_phone,
reg_date,
reg_time,
reg_year,
times,
lessons)
VALUES (
'".pnVarPrepForStore($first_name)."',
'".pnVarPrepForStore($last_name)."',
'".createRandomPassword()."'
'".pnVarPrepForStore($email)."',
'".pnVarPrepForStore($age)."',
'".pnVarPrepForStore($dob_1)."',
'".pnVarPrepForStore($dob_2)."',
'".pnVarPrepForStore($dob_3)."',
'".pnVarPrepForStore($s_address)."',
'".pnVarPrepForStore($s_city)."',
'".pnVarPrepForStore($s_state)."',
'".pnVarPrepForStore($s_zip)."',
'".pnVarPrepForStore($m_address)."',
'".pnVarPrepForStore($m_city)."',
'".pnVarPrepForStore($m_state)."',
'".pnVarPrepForStore($m_zip)."',
'".pnVarPrepForStore($mom_name)."',
'".pnVarPrepForStore($m_home_phone)."',
'".pnVarPrepForStore($m_summer_phone)."',
'".pnVarPrepForStore($m_work_phone)."',
'".pnVarPrepForStore($m_cell_phone)."',
'".pnVarPrepForStore($dad_name)."',
'".pnVarPrepForStore($d_home_phone)."',
'".pnVarPrepForStore($d_summer_phone)."',
'".pnVarPrepForStore($d_work_phone)."',
'".pnVarPrepForStore($d_cell_phone)."',
'".pnVarPrepForStore($staying_name)."',
'".pnVarPrepForStore($staying_relation)."',
'".pnVarPrepForStore($staying_address)."',
'".pnVarPrepForStore($staying_city)."',
'".pnVarPrepForStore($staying_state)."',
'".pnVarPrepForStore($staying_zip)."',
'".pnVarPrepForStore($staying_phone)."',
'".pnVarPrepForStore($pickup_name1)."',
'".pnVarPrepForStore($pickup_relation1)."',
'".pnVarPrepForStore($pickup_name2)."',
'".pnVarPrepForStore($pickup_relation2)."',
'".pnVarPrepForStore($pickup_name3)."',
'".pnVarPrepForStore($pickup_relation3)."',
'".pnVarPrepForStore($med_problem)."',
'".pnVarPrepForStore($med_explanation)."',
'".pnVarPrepForStore($meds)."',
'".pnVarPrepForStore($allergies)."',
'".pnVarPrepForStore($doctor)."',
'".pnVarPrepForStore($doctor_phone)."',
'".pnVarPrepForStore($dentist)."',
'".pnVarPrepForStore($dentist_phone)."',
'".pnVarPrepForStore($insurance)."',
'".pnVarPrepForStore($ins_id)."',
'".pnVarPrepForStore($em_1_name)."',
'".pnVarPrepForStore($em_1_relation)."',
'".pnVarPrepForStore($em_1_phone)."',
'".pnVarPrepForStore($em_2_name)."',
'".pnVarPrepForStore($em_2_relation)."',
'".pnVarPrepForStore($em_2_phone)."',
'$reg_date',
'$reg_time',
'$reg_year',
'".pnVarPrepForStore($time)."',
'".pnVarPrepForStore($lessons)."'
)")
or die (mysql_error());