[thelist] Photo Gallery Database Scheme

[Ron Dorman]

Hey Michele,

Have you checked out the Gallery projec <http://gallery.menalto.com/>t 
<http://gallery.menalto.com/>? It's free, open source, php & MySQL, so 
it will run on Win or Nix platforms. Handles sub ablums, and subs, and 
subs, etc. Even if you don't want to use the package for your project 
(it integrates nicely), you could look at the db scheme they use.

I have used it on a couple of projects and have been very pleased with 
it, and have two happy customers. Visit  TheLodgeTx.com 
<http://thelodgetx.com/> for an integrated example.

Have fun with the project,
Ron D.

Joshua Olson wrote:

>>-----Original Message-----
>>From: Michele Foster - WizarDev
>>Sent: Monday, June 13, 2005 8:03 PM
>>    
>>
>
>  
>
>>So, my question is ... should I have separate tables for each 
>>generation?
>>Or just one family table with all relationships.  I'm 
>>planning to have ID,
>>Title, Path, DateCreated, WhateverElseStrikesMyFancy, in the 
>>Parent table.
>>If I go the separate table route those tables will also have a field
>>ChildOf, or I can add it to the Family table, so for example
>>    
>>
>
>Michele,
>
>I'd shoot for one table, no matter what.  The exact contents of the table...
>well, that can vary.
>
>Start here:
>
>http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/404
>7/?format=print
>
><><><><><><><><><><>
>Joshua L. Olson
>WAE Tech Inc.
>http://www.waetech.com/
>Phone: 706.210.0168 
>
>Monitor bandwidth usage on IIS6 in real-time:
>http://www.waetech.com/services/iisbm/
>
>
>  
>


-- 
Simply Digital Technologies
www.simplydigtech.net
rwd at simplydigtech.net
817-503-7704 ofc
817-503-7719 fax
817-528-8947 cell