Re: Re: Photo Album Schema

just using id.gif immediately becomes problematic as each user is, by design, going to have multiple images. I know you could add a count to id, or mangle it, or any number of other things. But that takes us back into unnecessary complexity. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com ----- Original Message ----- From: "Bill Zeller" <billzeller@yahoo.com> To: "Steve Brett" <steve.brett@e-mis.com>; <php-db@lists.php.net> Sent: Thursday, August 23, 2001 10:28 AM Subject: Re: [PHP-DB] Re: Photo Album Schema > 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 <steve.brett@e-mis.com> wrote: > > 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_title > > > > -description (limited length) > > > > -userid (foreign key) > > > > would give you 1 album contains many photos, each > > photo relating to one > > album only. > > > > Steve > > > > > > > > "Tatare" <tatare99@yahoo.com> wrote in message > > news:20010821210859.21862.qmail@pb1.pair.com... > > > 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) > > > > -photoid (primary key) > > > > > > reguards. > > > tatare, > > > http://www.memoroo.fr.st > > > (not already available in english - could anyone > > help me to translate it > > ?) > > > > > > Jeff Oien <jeff@webdesigns1.com> a écrit dans le > > message : > > > > > PGEBKOPJJHHICHGDKCCIOEPBDAAA.jeff@webdesigns1.com... > > > > I want to make a photo album that will have > > users who sign up > > > > to create an album and then have the albums open > > to the public. > > > > I was thinking of doing it like this but I've > > never done a relational > > > > database before so if anyone thinks of anything > > I should change > > > > please let me know. Thanks. > > > > Jeff Oien > > > > > > > > Table1: > > > > -username > > > > -password > > > > -album_title > > > > -creation_date > > > > -id > > > > > > > > Table2: > > > > -id (from Table1) > > > > -photo (jpg or gif) > > > > -date > > > > -photo_title > > > > -description (limited length) > > > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: > > php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: > > php-db-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > > __________________________________________________ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net