title: MySQL Query Failed
body: <p>With the following code (html / SQL) the code fails to execute. I'm entirely great at MySQL but here is my code:</p>
  
  <p>
          <h2>Requested Orders</h2>
          Input Item and Quantity<br>
          <br></p>
  
  <pre><code>&lt;input type="text" name="email" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_one" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_two" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_three" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_four" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_five" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_six" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_seven" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_eight" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_nine" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_ten" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_eleven" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_twelve" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_thirteen" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_fourteen" size="40"&gt;&lt;br&gt;
  
  &lt;input type="text" name="item_fifthteen" size="40"&gt;&lt;br&gt;
  
  &lt;input type="submit" name="submit" value="Sent"&gt;
  </code></pre>
  
  <p>Here is the function.php</p>
  
  <pre><code>&lt;?php
  //the example of inserting data with variable from HTML form
  //function.php
  mysql_connect("localhost","root","");//database connection
  mysql_select_db("order_db");
  
  //inserting data order
  $order = "INSERT INTO requested_inventory
              (name, email, item_one, item_two, item_three, item_four, item_five, item_six, item_seven, item_eight, item_nine, item_ten, item_eleven, item_twelve, item_thirteen, item_fourteen, item_fifthteen)
              VALUES
              ('name',
              'email', 'item_one', 'item_two', 'item_three', 'item_four', 'item_five', 'item_six', 'item_seven', 'item_eight', 'item_eight', 'item_nine', 'item_ten', 'item_eleven', 'item_twelve', 'item_thirteen', 'item_fourteen', 'item_fifthteen')";
  
  //declare in the order variable
  $result = mysql_query('$order');    //order executes
  if($result){
      echo("&lt;br&gt;Input data is succeed");
  } else{
      echo("&lt;br&gt;Input data is fail");
  }
  ?&gt;
  </code></pre>
  
  <p>I am not sure where I have gone wrong. Any help with examples would be much appreciated.</p>
  
  <p>note: This is on a localhost machine so there is no need to full on security which is why I'm using root without a password.</p>