mysql query

[Piorun]

I've got problem with this line:

  
mysql_query(handler, "CREATE TABLE tc_example(id INT NOT NULL AUTO_INCREMENT)" ) 
  

What i'm doing wrong???

P.S.

handler return true, but table is not creating... -.-

[Citizen]

If you want to set 'AUTO_INCREMENT' on a column, you have to set this column as a primary key:

mysql_query(handler, "CREATE TABLE tc_exemple (id INT NOT NULL AUTO_INCREMENT ,PRIMARY KEY ( id ))" ) 

If it don't work, maybe the handler is wrong or you don't have the sufficient rights to create the table.