title: User Registration Table in PHPMYADMIN not storing any data added
body: <p>I am new to phpmyadmin and sql! I have created a database connection through dreamweaver CC using SecureWamp. It is all connected to my table etc but no matter how many times I enter information into my 'User Registeration' form, none of the information is showing in phpmyadmin. This is the code I have:
  Local Host Code:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
  # FileName="Connection_php_mysql.htm"
  # Type="MYSQL"
  # HTTP="true"
  $hostname_localhost = "localhost";
  $database_localhost = "XXXXX";
  $username_localhost = "XXXXX";
  $password_localhost = "XXXXX";
  $localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR); 
  ?&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>And this is the code that is on my actual user registration form page:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php require_once('Connections/localhost.php'); ?&gt;
  &lt;?php
  if (!function_exists("GetSQLValueString")) {
  function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
  {
    if (PHP_VERSION &lt; 6) {
      $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
    }
  
    $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  
    switch ($theType) {
      case "text":
        $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
        break;    
      case "long":
      case "int":
        $theValue = ($theValue != "") ? intval($theValue) : "NULL";
        break;
      case "double":
        $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
        break;
      case "date":
        $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
        break;
      case "defined":
        $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
        break;
    }
    return $theValue;
  }
  }
  
  $editFormAction = $_SERVER['PHP_SELF'];
  if (isset($_SERVER['QUERY_STRING'])) {
    $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
  }
  
  if ((isset($_POST["MM_insert"])) &amp;&amp; ($_POST["MM_insert"] == "form1")) {
    $insertSQL = sprintf("INSERT INTO usersregistration (FirstName, LastName, Email, Password) VALUES (%s, %s, %s, %s)",
                         GetSQLValueString($_POST['FirstName'], "text"),
                         GetSQLValueString($_POST['LastName'], "text"),
                         GetSQLValueString($_POST['email'], "text"),
                         GetSQLValueString($_POST['password'], "text"));
  
    mysql_select_db($database_localhost, $localhost);
    $Result1 = mysql_query($insertSQL, $localhost) or die(mysql_error());
  
    $insertGoTo = "Login.php";
    if (isset($_SERVER['QUERY_STRING'])) {
      $insertGoTo .= (strpos($insertGoTo, '?')) ? "&amp;" : "?";
      $insertGoTo .= $_SERVER['QUERY_STRING'];
    }
    header(sprintf("Location: %s", $insertGoTo));
  }
  
  mysql_select_db($database_localhost, $localhost);
  $query_Recordset1 = "SELECT * FROM usersregistration";
  $Recordset1 = mysql_query($query_Recordset1, $localhost) or die(mysql_error());
  $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($Recordset1);
  $query_Recordset1 = "SELECT * FROM usersregistration";
  $Recordset1 = mysql_query($query_Recordset1, $localhost) or die(mysql_error());
  $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($Recordset1);
  ?&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>Could anybody share their wisdom and tell me why nothing gets inserted into PHPmyadmin and how I can change it so the information is stored!</p>
  
  <p>Thank you!! :)</p>
  
  <p>** This is my form: </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;p&gt;
  &lt;form id="form1" name="form1" method="POST" action="&lt;?php echo $editFormAction; ?&gt;"&gt;
    &lt;table width="600" border="0" cellspacing="3"&gt;
      &lt;tbody&gt;
        &lt;tr&gt;
          &lt;td&gt;&lt;label for="FirstName"&gt;First Name &lt;/label&gt;
          &lt;input name="FirstName" type="text" required="required" id="FirstName" form="form1" title="FirstName" /&gt;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
          &lt;td&gt;Last Name 
            &lt;input name="LastName" type="text" required="required" id="LastName" form="form1" title="LastName" /&gt;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
          &lt;td&gt;&lt;label for="email"&gt;Email:&lt;/label&gt;
          &lt;input name="email" type="email" required="required" id="email" form="form1" title="Email" /&gt;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
          &lt;td&gt;&lt;label for="password"&gt;Password:&lt;/label&gt;
          &lt;input name="password" type="password" required="required" id="password" form="form1" title="Password" /&gt;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
          &lt;td&gt;&amp;nbsp;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
          &lt;td&gt;&lt;a href="Login.php" title="Register"&gt;Register&lt;/a&gt;&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/tbody&gt;
    &lt;/table&gt;
    &lt;input type="hidden" name="MM_insert" value="form1" /&gt;
  &lt;/form&gt;</code></pre>
  </div>
  </div>
  </p>