Gallery System

[redrabbit]

I'm having lots of trouble creating a gallery system.

The only person adding entries to this will be me. I have one table called "gallery" which looks like this:

ID Title Type Src

So ID, is just an integer which i manually increase. Title is something to describe the picture such as "Cool Computer", type is the type of picture like:

        *  Computer
        *  Humour
        *  Wierd

Well im having trouble coding it, and im thinking if it would be worth having an entire seperate table for each category. If i have less than 10 categories, then would it be worth having a table for each category ???

IT would be so much easier to code.

Anyone ?

[yelvington]

I assume you are using a database for all of this.

So ID, is just an integer which i manually increase.

No. ID should be autoincrement.

Well im having trouble coding it, and im thinking if it would be worth having an entire seperate table for each category. If i have less than 10 categories, then would it be worth having a table for each category ???

No. You should have a table of categories, and the "type" column in the "gallery" table should be a reference to an entry in the categories table.

Google "data modeling" and "relational model" for explanations.

[redrabbit]

What do you mean by:

No. You should have a table of categories, and the "type" column in the "gallery" table should be a reference to an entry in the categories table.

Can you explain a little better, with an example. ??