Image website in concept...need ideas here.

[Lt_Wolf]

I am currently working on a new website of mine, after my last one (a PBBG type game) failed.  Part of this website is going to be an image archive (think holybug.com). 

 

I want to have sub-categories for the images, but to still have a "view all" option.

 

My current idea is to give each image a name such as: bg-####.gif, the # symbols being it's assigned number.  For the every pic option, they will be selected in order of row ID.

 

For sub-categories (such as "Funny", "Video Games", "Military", "Misc", etc), they will each be assigned a number 1+.

 

The archive table in the mysql will be set up like this:

 

bgID --------It's assigned number

bgURL ------- Assigned URL

bgSUB ------- Sub category type

bgDESC ------ Description, or title associated with the picture.

 

 

 

Before I dive into this with that setup, does anyone else have a better idea?

[phpSensei]

The reason why your question isn't answered because no one can go through what you said and figure it out. Clearify your post, add point form notes and what your questions are. All i see is gibberish man, no offence.

[siapagweh]

still absurb though bout this topic... but here my doing

 

1. create table =>

 

table_directory

  id

  name_directory

 

table_img

  id

  id_directory

  name

  filename

 

2. create directory on ur system, which special for this file upload.

 

3. creating form for maintain directory or/and upload file... like mambo or jomla component for uploading media picture.

 

4. for maintain category or subcat... u can add another table for storing category stuff...

 

5. good luck

 

hope this helpfull