title: Insert PHP Array Into Two Columns
body: <p>I know it is possible to split an array to be inserted to multiple columns/rows but I just stumped.</p>
  
  <p>Say we have something like this....
  Array
  (
      [john] => blue
      [lee] => red
      [sylva] => green
      [paul] => black<br>
  )</p>
  
  <p>In my table, I have three columns namely id,name,color. How can I insert these elements so that the rows in my table are incremented (based on this array, it should be 4 rows altogether)..
  Thanks.</p>