Make a table for pictures. Something simple that has an id and your picture
then in your article table you just change your picture field to your
picture id field. You may want to do the same thing with category and any
other field if you notice that the article belongs in multiple categories.
----- Original Message -----
From: "kachaloo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 05, 2001 5:00 AM
Subject: [PHP-DB] 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 ,
> 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]
>
--
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]
