title: Simple PHP/MySQL Create Table Script
body: <p>So I have this script just to create a table in my database. I've copied it over from an old script I did that is working right now. How come this one is not working? Anyone? </p>
  
  <p>The error I am getting is <code>"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "'= varchar (20) NOT NULL, column_two = int NOT NULL auto_increment, column_thre' at line 2"</code></p>
  
  <pre><code>&lt;?php
  
  include("server_connect.php");
  
  mysql_select_db("assignment5");
  
  $create = "CREATE TABLE tbltable (
  column_one = varchar (20) NOT NULL,
  column_two = int NOT NULL auto_increment,
  column_three = int NOT NULL,
  column_four = varchar (15) NOT NULL,
  column_five = year,
  PRIMARY KEY = (column_one)
  )";
  
  $results = mysql_query($create) or die (mysql_error());
  
  echo "The tables have been created";
  
  ?&gt;
  </code></pre>