title: Error inserting data into MySQL Table via PHP
body: <p>I have a MySQL database with a table "AllParties". When I INSERT data into that table using PHP (below) I don't get an error, however, the data is not inserted into the table. I tried getting an error report from the MySQL server and, rather ambiguously, it said there is an error in MySQL Syntax. Please note I'm running my code in Mac CodeRunner, possibly this is the problem? Also, $con is a successful connection. </p>
  
  <pre><code>&lt;?php
  $con=mysqli_connect("sql3.freemysqlhosting.net","*********","********","*********");
  
  $name = "Will's Party";
  $date = 'October 1st, 2013';
  $housenum = '333 East Street';
  $city = "Golden Gate";
  $state = "California"; 
  $time = "7:00";
  $tag = "Serra";
  
  mysqli_select_db('AllParties', $con);
  
  $alpha = mysqli_query($con, 'INSERT INTO AllParties(Party Name, Date, House number and       street name, City, State, Time, Tag)  VALUES("$name","$date","$housenum","$city","$state","$time","$tag")');
  ?&gt;
  </code></pre>