title: MySQL skips inserting records to database
body: <p>I am getting an issue with <code>MySQL</code> or <code>PHP</code>; I am not sure. But, the issue is <code>PHP</code> query has been skipping the insertion of some records to the <code>MySQL</code> table. There are no entries for some records while the code seems fine when tested.</p>
  <p>I have been using this query to insert records into the database. Also, I am creating a string of queries and executing <code>multi_query</code> at some other place. While the string looks good and has been inserting records too. It's just some of the records that it skips.</p>
  <pre><code>INSERT INTO donations_detail (orderid, piece, amount, project_name, other, project_pay_name, dtype, project_code, project_sub_code) VALUES ('&quot;.$payid.&quot;', '&quot;.$piece.&quot;', '&quot;.$amount.&quot;', '&quot;.$row2[&quot;project_name&quot;].&quot;', '&quot;.$row[&quot;other&quot;].&quot;', '&quot;.$project_pay_name.&quot;', '&quot;.$row[&quot;dtype&quot;].&quot;', '&quot;.$row2[&quot;project_code&quot;].&quot;', '&quot;.$project_sub_code.&quot;');
  </code></pre>