I have this code
<?php
$link = mysql_connect( "localhost" );
$db = "hwk";
if ( ! $link ) die( "couldn't connect to MySQL" );
mysql_select_db( $db, $link )
or die ("Couldn't select $db: ".mysql_error ());
$query = "Create table hwkset ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( id ), group CHAR(8), subject CHAR(15), Staff CHAR(3), date DATE, hwkset MEDIUMTEXT )";
mysql_query( $query, $link )
or die ( "Couldn't create table hwkset: ".mysql_error ());
mysql_close( $link );
?>
but whenever i try to run the script i get this error
Couldn't create table hwkset: You have an error in your SQL syntax near 'group CHAR(8), subject CHAR(15), Staff CHAR(3), date DATE, hwkset MEDIUMTEXT )' at line 1
what am i doing wrong
<?php
$link = mysql_connect( "localhost" );
$db = "hwk";
if ( ! $link ) die( "couldn't connect to MySQL" );
mysql_select_db( $db, $link )
or die ("Couldn't select $db: ".mysql_error ());
$query = "Create table hwkset ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY( id ), group CHAR(8), subject CHAR(15), Staff CHAR(3), date DATE, hwkset MEDIUMTEXT )";
mysql_query( $query, $link )
or die ( "Couldn't create table hwkset: ".mysql_error ());
mysql_close( $link );
?>
but whenever i try to run the script i get this error
Couldn't create table hwkset: You have an error in your SQL syntax near 'group CHAR(8), subject CHAR(15), Staff CHAR(3), date DATE, hwkset MEDIUMTEXT )' at line 1
what am i doing wrong