[PHP-DB] Suggest Table Structure

[kachaloo]

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 ,
        PICTURE longblob ,
        KEYWORD varchar(30) NOT NULL DEFAULT '' ,
        FILENAME varchar(50) ,
        FILESIZE varchar(50) ,
        FILETYPE varchar(50) ,
        PRIMARY KEY (ID),
        UNIQUE ID (ID)
        
        
        But now I noticed some of the articles will have more than one
        picture... so how do I structure my table ?
        
        Thanks in advance,
        Vishal

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]