The following gives me an error at line 4.

CREATE TABLE inventory (Pro_id INT not null ,
Pro_gr_id INT ,
Bestel_id INT not null ,
Pro_naam VARCHAR not null ,
lat_na VARCHAR ,
Verp_materiaal VARCHAR ,
Verp_kleur VARCHAR ,
Ho_ingr VARCHAR ,
Sec_ingr VARCHAR ,
Verp_maat VARCHAR ,
H_lev VARCHAR not null ,
H_lev_telno INT not null ,
S_lev VARCHAR ,
S_lev_telno INT ,
Ink_ppm_G INT not null ,
Vrk_pps_G INT ,
Ink_ppm_E INT ,
Vrk_pps_E INT not null ,
Opmerking MEDIUMTEXT ,
Aanp_dat DATE ,
PRIMARY KEY (Pro_id));

any idea??

    I think VARCHAR needs the length of the field. Max length is 255, so you need to specify something like:

    Pro_naam VARCHAR(255) NOT NULL

    hope it works!

    -sridhar

      Thank u very much that I should have seen myself.(sob!) crazy thing is that this wa generated by phpmyadmin... I should have gotten a error warning or something which told me I had to fill in "this and that"
      greetz!

        Write a Reply...