Need a field / flag / status number for mutliple use ?
- by Jules
I want to create a field in my database which will be easy to query.
I think if I give a bit of background this will make more sense. My table has listings shown on my website. I run a program which looks at the listings a decides whether to hide them from being shown on the site. I also hide listings manually for various reasons.
I want to store these reasons in a field, so more than one reason could be made for hiding.
So I need some form of logic to determine which reasons have been used.
Can anyone offer me any guidance on what will be future-proof aka new reasons and what will be quick and easy to query upon ?