title: Inserting multiple values into the same column name + overwriting/update existing entries?
body: <p>This is a 2 part question which is pretty related, hence why I combined it into one:</p>
  
  <p><strong>Part 1</strong></p>
  
  <p>I have the arrays <code>$country</code> and <code>$redirect</code> each with up to 3 different values (a sum of six between them).</p>
  
  <p>I however, only have two columns in my table, <code>country</code> and <code>redirect</code>. I would like to use an insert query that would insert <code>$country[0], $country[1], etc</code> into the column <code>country</code> and the same for <code>$redirect[0], $redirect[1], etc</code> with the column <code>redirect</code>.</p>
  
  <p>This might be a stupid question, but would this INSERT query work, simply looping values to columns?</p>
  
  <pre><code>INSERT INTO table_name (country, redirect) values ('$country[0]', '$redirect[0]', '$country[1]', '$redirect[1]', '$country[2]', '$redirect[2]')
  </code></pre>
  
  <p>If not, how could I get this to work? I could use a <code>for</code> loop, but I'm concerned about the resource usage.</p>
  
  <hr>
  
  <p><strong>Part 2</strong></p>
  
  <p>How do I overwrite/update a row, where the value of column <code>country</code> already exists.</p>
  
  <p>For example, <code>Great Britain</code> already exists within the column <code>country</code> with <code>http://en-gb</code> in the same row but within the column <code>redirect</code>.</p>
  
  <p>I have an INSERT query such as <code>INSERT INTO table_name (country, redirect) VALUES ('Great Britain', 'http://uk')</code>, and I'd like to overwrite/update the row where <code>Great Britain</code> already exists within column <code>country</code> with the new <code>redirect</code> value.</p>
  
  <p>Any answers/comments would be very, very, very much appreciated :)!!</p>