Organize a bunch of pictures

Anon

I plan on having about 100 family pictures scanned on a family website. I'm looking for the best way to organize these pictures for viewing on the site. And now, the only way I can see are links like, Catagories, subcatagories, actual pictures etc.

I'm having a hard time trying to set up the tables and the relationships between them.

For example,
I have a picture img001.jpg with Joe and Mary on it at a birthday party. That same picture would be in different catagories: people, special events; and subcatagories birthday parties, Joe, Mary.

I want the viewer to click on catagory, then subcatagory and then a thumbnail that will have the pictures displayed LIMITed, using navigational prev, next links.

Has someone done something like this before? Maybe I'm going about this the wrong way and someone can point me in the right, better direction. How do I show the hierarchial relationship in a table? Any input appriciated.

Thanks.

tasistro

Try two tables like this:

Table photos

ID/Name/filepath/filename/description

Table categories

ID/photo/category

In table photos you set ID as autoincrement and primary key, Name is a user given name for the file, filepath is the location in the server, filename is well..., description is a set of keywords.

Table categories is set up as follows:
ID is again a primary autoincrement key, photo is a field where ID field of the photos table is stored (photos.ID). If a photo fits a category an entry is placed in the categories table

Given your example

Entry for photos table

ID/Name/filepath/filename/description

1/Mary_and_Joe/imgdir/img001.jpg/Joe Mary birthday party

Entry for category table

ID/photo/category
1/1/people
2/1/special events
3/1/birthday parties

You then join the tables on a SQL

select * from photos, category where photos.ID=category.photo and category.category="people" or category.category="special events"

This SQL selects all photos that belong to the people and special events category. You could also add : photos.description like "%mary%" to select all records that include mary...etc.

Hope it helps

Saludos
Gerardo

Anon

I would do something like this:

Set your image table up like this:

columns:
imageid
image
image_thumb
bitmask

then I'd have another table tieing the categories to the bitmask, like this:

columns:
category
bitmask

people 1
places 2
things 4
etc...

You could even add a 2nd bitmask for subcategories or just additional bits for certain categories. I'm not sure what db your going to use, but most that I know of can do a select by bitwise operation, and you should be able to find that in the db's documentation.