title: php mysql insert into statement
body: <p>When running this code in the web page I do not get a confirmation that it is complete. I took the sql code directly from phpmyadmin sql query window. I would like a little help to this issue. it effects all the add pages. </p>
  
  <p>id </p>
  
  <pre><code>$results=mysqli_query($con, "select * from Users where `userName` ='$userName'");
  $row = mysqli_fetch_array($results);
  $id = $row['id_cust'];
  </code></pre>
  
  <p>that is before this statement </p>
  
  <p>php </p>
  
  <pre><code>if(isset($_POST['insert'])){
  $artist = $_POST['artist'];
  $place = $_POST['place'];
  $hour = $_POST['hour'];
  $minute = $_POST['min'];
  $year = $_POST['year'];
  $month = $_POST['month'];
  $day = $_POST['day'];
  $price = $_POST['price'];
  $open = $_POST['open'];
  $time = $hour.':'.$minute;
  $date = $year.'-'.$month.'-'.$day;
  $result=mysqli_query($con,"insert into Concert values('$id','$artist','$date','$time','$place','$price','$open')");
      if($result)
      {
      echo 'Values updated successfully';
      }
  }
  </code></pre>
  
  <p>html </p>
  
  <pre><code>&lt;form name="addconcerts" method="post" action="addconcert.php" id="form"&gt;
  &lt;p&gt;Please Fill out all information&lt;/p&gt;
  Artist:&lt;input type="text" name="artist" /&gt; &lt;br /&gt;
  Place:&lt;input type="text" name="place" /&gt;&lt;br /&gt;
  Approximant start time&lt;select name="hour"&gt;
  &lt;option value=""&gt;Hour&lt;/option&gt;
  &lt;option value="01"&gt;01&lt;/option&gt;
   """"""""
  &lt;option value="24"&gt;24&lt;/option&gt;
  &lt;/select&gt;
  &lt;select name="min"&gt;
  &lt;option value=""&gt;Minute&lt;/option&gt;
  &lt;option value="00"&gt;00&lt;/option&gt;
  &lt;option value="15"&gt;15&lt;/option&gt;
  &lt;option value="30"&gt;30&lt;/option&gt;
  &lt;option value="45"&gt;35&lt;/option&gt;
  &lt;/select&gt;&lt;br /&gt;
  &lt;select name="month"&gt;
  &lt;option value=""&gt;Month&lt;/option&gt;
  &lt;option value = "01"&gt;January&lt;/option&gt;
   """"""""""""""""
  &lt;option value = "12"&gt;December&lt;/option&gt; 
   &lt;/select&gt;
  &lt;select name="day"&gt;
  &lt;option value=""&gt;Day&lt;/option&gt;
  &lt;option value="01"&gt;01&lt;/option&gt;
  """"""""""""""""""
  &lt;option value="31"&gt;31&lt;/option&gt;
  &lt;/select&gt;
  &lt;select name="year"&gt;
  &lt;option value=""&gt;Year&lt;/option&gt;
  &lt;option value="2014"&gt;2014&lt;/option&gt;
  &lt;option value="2015"&gt;2015&lt;/option&gt; 
  &lt;/select&gt;&lt;br /&gt;
  Price:&lt;input type="text" name="price"&gt;&lt;br /&gt;
  Opening Act:&lt;input type="text" name="open"&gt;&lt;br&gt;&lt;br&gt;
  &lt;input type="reset" name="reset" value="Reset"&gt;
  &lt;input type="submit" name="insert" value="insert"&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>any help would be greatly appreciated. </p>