HTML dropdown only inputs last row to my SQL

manpreet Best Answer 3 years ago

I am a newbie to PHP and trying to create a web-interfaced feedback application. I have created a table in HTML with 5 rows and have scripted it to mysql via PHP file. When I hit submit, the last row entries are added 5 times instead of all rows giving single input each.

HTML form

 action="insert.php" method="post">
 border="3">

Faculty NameSubjectSubject KnowledgeTeaching 

MeathodlogyPunctualitySyllabus CoverageResponsiveness to Queries


 
     name="staff">
    value="staff1">Staff1
    value="staff2">Staff2
    value="staff3">Staff3
    value="staff4">Staff4
    value="staff5">Staff5
 
  
   name="subject">
    value="sub1">Sub1
    value="sub2">Sub2
    value="sub3">Sub3
    value="sub4">Sub4
    value="sub5">Sub5
 
 
    name="Rate1">
    value="1">1
    value="2">2
    value="3">3
    value="4">4
    value="5">5
   
 
 
    name="Rate2">
    value="1">1
    value="2">2
    value="3">3
    value="4">4
    value="5">5
   
  
  
    name="Rate3">
    value="1">1
    value="2">2
    value="3">3
    
                                                

                                                                                                        
                                                    
                                                
                                                

                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares
                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp