title: MySQL query error (using php)
body: <p>I have problem with this query.</p>
  
  <pre><code> $query = 'CREATE TABLE movie(
      movie_id UNSIGNED INTEGER NOT NULL AUTO_INCREMENT,
      movie_name VARCHAR(255) NOT NULL,
      movie_type TINYINT NOT NULL DEFAULT 0,
      movie_year SMALLINT UNSIGNED NOT NULL DEFAULT 0,
      movie_leadactor INTEGER UNSIGNED NOT NULL DEFAULT 0,
      movie_director INTEGER UNSIGNED NOT NULL DEFAULT 0,
  
      PRIMARY KEY (movie_id),
      KEY movie_type (movie_type, movie_year)
      )
      ENGINE=MyISAM';
   $result = mysql_query($query, $db) or die(mysql_error($db));
  </code></pre>
  
  <p>it still write this:</p>
  
  <blockquote>
    <p>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 'UNSIGNED INTEGER NOT NULL AUTO_INCREMENT, movie_name VARCHAR(255) NOT NULL, ' at line 2</p>
  </blockquote>