title: MYSQL create a line with every new user
body: <p>I have a little problem</p>
  
  <p>I want to create a script, that creates a new line in the table, if there is a new user and in the line, change the "points" columme to zero(0)</p>
  
  <p>This is my current code:</p>
  
  <pre><code>&lt;?php
  header('Content-Type: text/html; charset=Windows-1250');    
  $firstName = $_POST['firstname'];
  
  
  
  $servername = "db.mysql-01.gsp-europe.net";
  $username = "xxxxxxxxxx";
  $password = "xxxxxxxxxxx";
  $dbname = "xxxxxxxxxxx";
  
  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn-&gt;connect_error) {
      die("Connection failed: " . $conn-&gt;connect_error);
  } 
  
  // sql to create table
  
  $sql = "UPDATE `member_profile` SET points = points + 1 WHERE user_id = '$firstName'";
  
  
  if ($conn-&gt;query($sql) === TRUE) {
      echo "Thingz created successfully";
  } else {
      echo "Error doing sum thingz: " . $conn-&gt;error;
  }
  
  $conn-&gt;close();
  
  
  
  ?&gt;
  </code></pre>
  
  <p>What i need in the cube: When there new user_id ($firstName) appear, create new line with this user name, and change the "points" columme from "null" into Zero(0)</p>
  
  <p>Thanks for yout time, I appreciate it</p>