title: Is there a limit on record updates for MySQL in PHP?
body: <p>I wrote a PHP script to do some color conversions from  Hexadecimal to RGB and HSL values and store them in a database. My current dataset is the entire Pantone Solid Coated color book which is 1341 colors. I have the Hexadecimal values already in there.</p>
  
  <p>From there I accessed the database and took the Hex value and did the two conversions and then stored them back in the table.</p>
  
  <p>I am getting no errors, but the process seems to stop at record 499 for the updates even though the echo of all the values I did for testing show the calculations being applied to all 1341 colors.</p>
  
  <p>Here is the script I have so far:</p>
  
  <pre><code>// SQL Server Login Info Removed
  $sql_connection = new mysqli($sql_server, $sql_username, $sql_password, $sql_database);
  
  if ($sql_connection-&gt;connect_error) {
      die("Connection Failed: " . $sql_connection-&gt;connect_error);
  }
  
  $query = "SELECT * FROM coated";
  $result = $sql_connection-&gt;query($query);
  
  if ($result-&gt;num_rows &gt; 0) {
      while($row = $result-&gt;fetch_assoc()) {
          $colorname = $row["mapName"];
          $hexvalue = $row["hex"];
  
          if ($row["rgb"] == '') {
              $rgbvalue = hex2rgb($hexvalue);
          } else {
              $rgbvalue = $row["rgb"];
          }
          if ($row["hsl"] == '') {
              $hslvalue = hex2hsl($hexvalue);
          } else {
              $hslvalue = $row["hsl"];
          }
  
          //echo "Color: " . $row["mapName"] . " | " . $rgbvalue . " | " . $hslvalue . "&lt;br&gt;";
  
          $wrt_query = "UPDATE coated SET hex='".$hexvalue."', rgb='".$rgbvalue."', hsl='".$hslvalue."' WHERE mapName='".$colorname."'";
          if ($sql_connection-&gt;query($wrt_query) === true) {
              echo "Record for " . $colorname . " updated &lt;br&gt;";
          } else {
              echo "Error updating record for " . $colorname . "&lt;br&gt;";
          }
      }
  }
  </code></pre>
  
  <p>The data comes from a CSV file. Here is a excerpt:</p>
  
  <pre><code>pantone-Yellow-C,#fedd00
  pantone-Yellow-012-C,#ffd700
  pantone-Orange-021-C,#fe5000
  pantone-Warm-Red-C,#f9423a
  pantone-Red-032-C,#ef3340
  pantone-Rubine-Red-C,#ce0058
  pantone-Rhodamine-Red-C,#e10098
  pantone-Purple-C,#bb29bb
  pantone-Violet-C,#440099
  pantone-Blue-072-C,#10069f
  pantone-Reflex-Blue-C,#001489
  pantone-Process-Blue-C,#0085ca
  pantone-Green-C,#00ab84
  pantone-Black-C,#2d2926
  pantone-Yellow-0131-C,#f2f0a1
  pantone-Red-0331-C,#fcaebb
  pantone-Magenta-0521-C,#f1b2dc
  pantone-Violet-0631-C,#bf9bde
  pantone-Blue-0821-C,#74d1ea
  pantone-Green-0921-C,#9de7d7
  pantone-Black-0961-C,#9e978e
  ...
  pantone-Black-2-C,#332f21
  pantone-Black-3-C,#212721
  pantone-Black-4-C,#31261d
  pantone-Black-5-C,#3e2b2e
  pantone-Black-6-C,#101820
  pantone-Black-7-C,#3d3935
  </code></pre>