[RESOLVED] Query Error Help

[focus310]

Hello:

I'm trying to run a query and I'm receiving the following message:
Column count doesn't match value count at row 1.

I printed my table structure and cross-referenced to my insert statement and everything seems to be in order. I also printed a detail error message showing me the data for each field. I cross-referenced the data with the table and everything seems correct. I don't know what I'm missing.

Can someone help me out?

This is my query statement:

$query4 = "REPLACE INTO initial_plan (client_id, caseno, legal_status, emergency_no, ed_voc_status, ed_voc_stat_other, special_services, strength_assessment, reason_for_admin, 
                   meds1, meds2, meds3, meds4, meds5, dosage1, dosage2, dosage3, dosage4, dosage5, last_dental, medical_history, current_med_needs, 
                   special_behavior_concerns1, special_behavior_concerns2, special_behavior_concerns3, special_behavior_concerns4, special_behavior_concerns5, 
                   isp_deadline, treatment_need1, treatment_goal1, treatment_need2, treatment_goal2, treatment_need3, treatment_goal3, treatment_need4, treatment_goal4, treatment_need5, treatment_goal5, treatment_need6, treatment_goal6,
                   recommend_assessment, fund_agency, level_of_care, fund_rate) 


VALUES ('$_POST[client_id]', '$_POST[caseno]', '$_POST[legal_status]', '$_POST[emergency_no]', '$_POST[ed_voc_status]', '$_POST[ed_voc_stat_other]', 
                 '$_POST[special_services]', '$_POST[strength_assessment]', '$_POST[reason_for_admin]', '$_POST[meds1]', '$_POST[meds2]', '$_POST[meds3]', '$_POST[meds4]', 
                 '$_POST[meds5]', '$_POST[dosage1]', '$_POST[dosage2]', '$_POST[dosage3]', '$_POST[dosage4]', 
                 '$_POST[dosage5]', '$_POST[last_dental]', '$_POST[medical_history]', '$_POST[current_med_needs]', '$_POST[special_behavior_concerns1]', '$_POST[special_behavior_concerns2]', 
                 '$_POST[special_behavior_concerns3]', '$_POST[special_behavior_concerns4]', '$_POST[special_behavior_concerns5]', '$_POST[isp_deadline]', '$_POST[treatment_need1]', 
                 '$_POST[treatment_goal1]', '$_POST[treatment_need2]', '$_POST[treatment_goal2]', '$_POST[treatment_need3]' 
                 '$_POST[treatment_goal3]', '$_POST[treatment_need4]', '$_POST[treatment_goal4]', '$_POST[treatment_need5]', '$_POST[treatment_goal5]', '$_POST[treatment_need6]', '$_POST[treatment_goal6]', '$_POST[recommend_assessment]', 
                 '$_POST[fund_agency]', '$_POST[level_of_care]', '$_POST[fund_rate]')"; 

Thanks for the help.

[Piranha]

That error message means that you don't have the same number of columns in the column name part and in the value part.

But you have errors that should be handled before you even think about this. First you should normalize the database to at least normal form 3 (now it is not even normal form 1). Then you should make sure that the inserted variables are safe for sql injection.

To get more information search for "normalization" and "sql injection".

[focus310]

Hi,

Apparently the problem was a missing column.

[Piranha]

Note that I really recommend that you solve the other two problems before you continue to develope. If you don't solve those problems you will get into trouble.