Re: [PHP] Suggest Table Structure

Hi, you have to break your table in pieces and create tables for items that occur more than once. For example: CREATE TABLE articles ( ID int(6) NOT NULL auto_increment, id_category UNSIGNED INT REFERENCES category, HEADING varchar(30) NOT NULL DEFAULT '' , BODY longblob , ...) CREATE TABLE pic

[PHP] Suggest Table Structure

Hi guys, I am making a table which will store articles for a site and the feilds are : ID int(6) NOT NULL auto_increment, CATEORY varchar(10) NOT NULL DEFAULT 'EVENTS' , HEADING varchar(30) NOT NULL DEFAULT '' , BODY longblob , PICTU