bambookaat

PLease see the programme and suggest an error in it. IT is only entering a Last value in the table. Why? if($programme=='CE') $sql6=mysql_query("update registrationsep07sep07 set subject='CE001D' where regno='$del_id'"); $sql7=mysql_query("update registrationsep07sep07 set subject='CE002D' where regno='$del_id'"); $sq18=mysql_query("update registrationsep07sep07 set subject='CE003D' where regno='$del_id'"); $sql19=mysql_query("update registrationsep07sep07 set subject='CS036D'where regno='$del_id'"); $sql20=mysql_query("update registrationsep07sep07 set subject='MA001D'where regno='$del_id'"); if($programme=='CSE') $sq21=mysql_query("update registrationsep07sep07 set subject='CS001D' where regno='$del_id'"); $sql7=mysql_query("update registrationsep07sep07 set subject='CS002D' where subject<>'MA001D' and regno='$del_id'"); $sql8=mysql_query("update registrationsep07sep07 set subject='EE001D' where regno='$del_id'"); $sql9=mysql_query("update registrationsep07sep07 set subject='EE007D' where regno='$del_id'"); $sql20=mysql_query("update registrationsep07sep07 set subject='MA001D' where regno='$del_id'"); if($programme=='EE') $sql21=mysql_query("update registrationsep07sep07 set subject='EE001D' where regno='$del_id'"); $sql22=mysql_query("update registrationsep07sep07 set subject='EE002D' where regno='$del_id'"); $sql23=mysql_query("update registrationsep07sep07 set subject='EE003D' where regno='$del_id'"); $sql24=mysql_query("update registrationsep07sep07 set subject='EE004D' where regno='$del_id'"); $sql25=mysql_query("update registrationsep07sep07 set subject='MA001D' where regno='$del_id'"); O