[eluser]boltsabre[/eluser]
There is no "categories" table as such (categories have been isolated to a helper function, which returns a multi-dimensional array to minimises DB hits and inherent caching problems. Categories are set in stone - if I need to add more in the future I'm happy to add to the array manually in the file itself - it's a personal website, I'm not worried about the client ringing up every 3 days saying "add this cat, remove this cat", or wanting the functionality to add/edit/delete/deactivate/archive categories, etc).
Quote:best to work through a few tutorials on sql & schema design if this is all new to you
It's not so much as new (I learnt it when I was studying, I'm well aware of the concept of join table to create a relationship between two entities, and how to implement it correctly), but considering I don't have two tables to join, I was wondering if there was a better way (I terms of speed of db requests).
Thanks for the input, unless I hear back regarding some other idea, I'll go with the second, seems the easiest to implement and create my admin "image upload" script.
Thanks for the input jmadsen!!!