rks much
> better.
>
> Sheridan Saint-Michel
> Website Administrator
> FoxJet, an ITW Company
> www.foxjet.com
>
> - Original Message -
> From: "grant" <[EMAIL PROTECTED]>
> To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]
"Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message
00f601c12ca3$8bb26420$[EMAIL PROTECTED]">news:00f601c12ca3$8bb26420$[EMAIL PROTECTED]...
> From: "Hugh Bothwell" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> >
> > "Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message
> > 03a
Message -
From: "Hugh Bothwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 8:02 PM
Subject: Re: [PHP-DB] Re: Photo Album Schema
>
> "Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message
> 03a901c12c02$c60d464
"Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message
03a901c12c02$c60d4640$[EMAIL PROTECTED]">news:03a901c12c02$c60d4640$[EMAIL PROTECTED]...
> I don't know if having multiple users associated with a single image is
> at all beneficial, and I can see where it might cause all sorts of
prob
However, the concept of the filename on the drive having nothing to do
with the real original useful filename was the real point. You can then
save whatever type of file you want, point to it, and tell the user on the
other end what to save it as.
oxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "grant" <[EMAIL PROTECTED]>
To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>
Cc: "Bill Zeller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 1:48 P
The most useful schema would be to have the name of the document be system
generated, like i123456789.img and make the database as follows:
Image
Image_Name varchar(50) primary key
Original_Name varchar(50)
Description text
User
User_ID int8 primary key
Login char(8) uniques index
password varch
, an ITW Company
www.foxjet.com
- Original Message -
From: "Bill Zeller" <[EMAIL PROTECTED]>
To: "Steve Brett" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 10:28 AM
Subject: Re: [PHP-DB] Re: Photo Album Schema
> Hi,
&g
Hi,
I can see absolutely no reason to store the name of
the image with the picture?
Why not, whether using one directory or one for each
user, just do id.gif?
Best Regards,
Bill Zeller
--- Steve Brett <[EMAIL PROTECTED]> wrote:
> that would generally work on the assumption that
> many photos ca
that would generally work on the assumption that many photos can belong to
many albums. possibly a bad thing.
> table 1
> > -userid (primary key)
> > -username
> > -password
> > -album_title
> > -creation_date
>
> table 2
> > -photoid (primary key)
> > -photo (jpg or gif)
> > -date
> > -photo_tit
I'd rather do it like this (but I'm not sure it's ok...)
table 1
> -userid (primary key)
> -username
> -password
> -album_title
> -creation_date
table 2
> -photoid (primary key)
> -photo (jpg or gif)
> -date
> -photo_title
> -description (limited length)
table 3
> -userid (primary key)
> -photo
11 matches
Mail list logo
