title: how insert multiple rows to mysql over json from android?
body: <p>I´m trying insert multiple rows to mysql db from android, but I only know how insert one row</p>
  
  <p>php script:
      
  
  <pre><code>$r=mysql_query($sql);
  if(!$r)
  echo "Error in query: ".mysql_error();
  mysql_close();
  ?&gt;
  </code></pre>
  
  <p>part of android file:</p>
  
  <pre><code>    param = new ArrayList&lt;NameValuePair&gt;();
      param.add(new BasicNameValuePair("c_name", city));
      param.add(new BasicNameValuePair("s_name", street));
  
      HttpClient httpClient = new DefaultHttpClient();
      HttpPost httpPost = new HttpPost(url_select);
  </code></pre>
  
  <p>will it work if I add more entries to param arraylist? In loop?
  Something like</p>
  
  <pre><code>for (String[] s : examp){
      param.add(new BasicNameValuePair("c_name", s[0]));
      param.add(new BasicNameValuePair("s_name", s[1]));
  }
  </code></pre>
  
  <p>Or how i can do this? Thanks.</p>