Just had another question come to me which relates to this very same database....
Here is my table structure:
Because I may have various images of the same product, would it be best to create individual tables for the products, so that if the user wants to just view 'pet housing' for instance, it would be easier to select all the data relating to pet housing.
Can I create an extra field within my original table, for example 'tags', and just insert ALL products into this table, but give them certain tags when doing so. This is so I can determine which products to display using the tag field.
Please let me know your thoughts because I'm stuck and can't carry on without knowing the best way to go about this.
Thank you for any help