title: submit multiple values from a textfield with the same name
body: <p>i have a form, the carries two textfields with the name attributes "name" and "amount"</p>
  
  <pre><code>&lt;form method="post" name="form1" id="form1" action="test.php"&gt;
  &lt;input type="text" name="name" value="wole" size="32" required="required" /&gt;
    &lt;input type="text" name="amount" value="100" size="32" required="required" /&gt;
    &lt;input type="text" name="name" value="yetunde" size="32" required="required" /&gt;
    &lt;input type="text" name="amount" value="200" size="32" required="required" /&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>my intention is to capture name and amount side by side in two rows, based on how my form is structured.</p>
  
  <p>i have tried submittin the data into the database using this snippet</p>
  
  <pre><code>$sql="INSERT INTO records(name,  amount)VALUES('$_POST[name]', '$_POST[amount]')";
  </code></pre>
  
  <p>but it only submits one row of data, "wole and 100", how can i make sure i capture the two different rows from my form</p>