Creating mysql structure

[mwichmann4]

Hey everyone,

I have this sql structure code that I am trying to execute using php with the mysql_query, and everytime it goes through without errors but then I check the database and there are no tables in it.
Here is the mysql code, I am not sure what it is not understanding.

CREATE TABLE image_folders (
id int(255) NOT NULL auto_increment,
folder_name varchar(50) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE images (
id int(255) NOT NULL auto_increment,
folder_belong varchar(50) NOT NULL default '',
image_name varchar(100) NOT NULL default '',
width int(4) NOT NULL default '0',
height int(4) NOT NULL default '0',
display char(3) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

thanks for the help

[laserlight]

hmm...
folder_name varchar(50) NOT NULL default ''

it seems that you declared it NOT NULL yet set a null value as the default.
Could that be the problem?

maybe:
width int(4) NOT NULL default '0'

should be:
width int(4) NOT NULL default 0
?