title: Problem with MYSQL database, values are not inserted
body: <p>I am trying to insert values in database and values are not being inserted, here is the code i have:</p>
  
  <pre><code>    $user_name = "username";
      $password = "password";
      $database = "database";
      $server = "localhost";
      $db_handle = mysql_connect($server, $user_name, $password);
      $db_found = mysql_select_db($database, $db_handle);
  
      if ($db_found) {
  
      $SQL = 'INSERT INTO table (anInt, DomainName, URL, Rank, PageRank, Google, Bing, Boss, IndexedPage, Backlinks) VALUES ($anInt, $Domain, $URL, $Rank, $Pagerank, $Google, $Bing, $Yahoo, $Pages, $backlinks)';
      $result = mysql_query($SQL);
      mysql_close($db_handle);
  
      print "Records added to the database";
  </code></pre>
  
  <p>it is printing that records added to the database but when looking at the database nothing is being added. some of the values are doubles, text, and ints. Is there anyway to debug this? I will be adding more information to the post if someone asks me to.</p>
  
  <p>and of course I have an else statement i just thought it is not relevant since it is telling me that records are added.</p>