<?php
CREATE TABLE test (id_col, INT, NOT NULL, AUTO_INCREMENT, PRIMARY KEY,
col1 TEXT NULL INDEX,
col2 DATE NOT NULL
);
mysql_connect(localhost,dbe2k2,DBGTZZ);
mysql_select_db('test');
$query="INSERT INTO test(ID,'col1','col2') VALUES(NULL, 'Hey', 'Andy')";
$result=mysql_query($query);
print $result;
?>

I'm just testing this MySQL thing, but it always says CREATE TABLE test (id_col, INT, NOT NULL, AUTO_INCREMENT, PRIMARY KEY,
is wrong, can someone help me please.