title: Resource id # 4 php
body: <p>everytime i try and add one to the second column of a certain name, it changes the value to 5, if i echo my event it says it is equal to resource id #4. Anyone have any fixes?</p>
  
  <pre><code>&lt;form action="new.php" method="POST"&gt;
  &lt;input type="text" name="input_value"&gt;
  &lt;br /&gt;
  &lt;input name="new_User" type="submit" value="Add to Users"&gt;
  &lt;input type="submit" name="event_Up" value="Attended Event"&gt;
  &lt;?php
  //Connect to Database
  mysql_connect("localhost", "root", "");
  
  //If Add New user butten is clicked execute
  
  if (isset($_POST['new_User']))
  {
  $username = $_POST['input_value'];
  $make = "INSERT INTO `my_db`.`profile` (`Name`, `Events`) VALUES ('$username', '1')";
  mysql_query($make);
  
  }
  //If Event up is pushed then add one
  
  if (isset($_POST['event_Up']))
  {
  $username = $_POST['input_value'];
  $event = mysql_query("SELECT 'Events' FROM `my_db`.`profile` WHERE Name ='$username'");
  $newEvent = $event +1;
  $update = "UPDATE `my_db`.`profile` SET Events = '$newEvent' WHERE Name = '$username'";
  mysql_query($update);
  }
  
  //Print Table
  $data = mysql_query("SELECT * FROM `my_db`.`profile`");
  Print "&lt;table border cellpadding=4&gt;";
  while($info = mysql_fetch_array($data))
  {
  Print "&lt;tr&gt;";
  Print "&lt;th&gt;Name:&lt;/th&gt; &lt;td&gt; ".$info['Name'] . "&lt;/td&gt;";
  Print "&lt;th&gt;Events:&lt;/th&gt; &lt;td&gt;".$info['Events'] . " &lt;/td&gt;";
  }
  Print "&lt;/table&gt;";
  
  ?&gt; 
  </code></pre>