Hello everybody,
Am I doing right for update code.
my code is like this.
there is error when I run it..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 'SET year='', SET noofstudents='', SET minutes ='', SET ability='', SET learn' at line 1
MAny thanks for help
mysql_query("UPDATE lesson SET subject='{$ins_subject}', SET year='{$ins_year}', SET noofstudents='{$ins_noofstudents}', SET minutes ='{$ins_minutes}', SET ability='{$ins_ability}', SET learningArea ='{$ins_learningArea}', SET objectives='{$ins_objectives}', SET LO='{$ins_LO}', SET skills='{$ins_skills}', SET prerequisite ='{$ins_prerequisite}',SET resources ='{$ins_resources}',SET introduction ='{$ins_introduction}',SET activity ='{$ins_activity}', SET step2='{$ins_step2}', SET step3='{$ins_step3}', SET step4 ='{$ins_step4}', SET assessment ='{$ins_assessment}', SET reflection ='{$ins_reflection}', SET closure ='{$ins_closure}', SET extension ='{$ins_extension}', SET verified ='{$ins_verified}' WHERE lessonID = $id)")
or die(mysql_error());
