title: generate 100 10-digit random numbers and save to database
body: <p>This is a pretty simple function yet it keeps giving me errors. Im writing a script to generate 100 10-digit random numbers but I keep having this error: "check the manual that corresponds to your MySQL server version for the right syntax to use near <code>'rand(1111111111, 9999999999)'</code> at line 1.</p>
  
  <p>This is my code</p>
  
  <pre><code>&lt;?php
  $cxn = new mysqli("localhost", "CJroot", "password", "random");
  
  /* check connection */
  if (mysqli_connect_errno()) {
      printf("Connect failed: %s\n", mysqli_connect_error());
      exit();
  }
  for ($i=0; $i &lt; 100; $i++) { 
      $sql = "INSERT INTO random (random) VALUES 'rand(1111111111, 9999999999)'";
      if(!mysqli_query($cxn,$sql)) {
          die("Error: ".mysqli_error($cxn));
      }
  }
  
  /* close connection */
  $cxn-&gt;close();
  ?&gt;
  </code></pre>