Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

[PHP-DB] Suggest Table Structure From: kachaloo (kachaloo <email protected>)
Date: 07/05/01

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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>