Newbie with databases, I would like some advise please.. I have agencies who can download photo's. Standard each agency can download "medium" & "large" photos. Now from their account page I would like them to make extra custom presets and manage those.
I looked in the database of some blog software how they handle categories and wrapped my head around this example. Is this the right approach?
agency 1 has preset "medium" & "large" agency 2 has preset "medium", "large" & "Bill custom"
names would be accessed $size_name = $sizes[$row];
for both languages.
Two reasons. First numeric lookups will always be faster than textual ones. Second there is the eventuality (or likelihood) these values will be used in other areas of the programming to size or crop the images and you can access them directly rather than associating the textual values with the numeric ones.