hey,
does anyone know the solution to this message:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order(o_id),
PRIMARY KEY (photo_id)
) TYPE=MyISAM AUTO_INCREMENT=4' at line 6
HERE IS MY CODE::
CREATE TABLE orderline (
photo_id int(6) NOT NULL auto_increment,
picture varchar(30) NOT NULL default '',
amount int(5) NOT NULL default '',
type_id int(6) NOT NULL REFERENCES type(type_id),
o_id int(6) NOT NULL REFERENCES order(o_id),
PRIMARY KEY (photo_id)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
many thanks
