Hello all hope your all well.
I hope someone can help me work this out.
I have a database set up that has recipes and food requirements.
Each recipe can have more then one food requirement.
eg:
Sweet Chicken Curry may contain: Nuts, Milk etc etc
The tables are set up like this
cms_recipe
recipe_id
recipe_ingrediants
recipe_method
cms_dietary
dietary_id
dietary_name
cms_recipe_dietary
recipe_id
dietary_id
How can i construct a query that loops through a checkbox array and brings back all the recipes that don’t have the dietary requirements in them.
i reakon it would use joins and such but have no idea what the best way to do this or the least clumsy
Please note that the dietary table can be added to at later date.
Hope that makes sense.
ps mind my spelling i’m working on a tablet pc and haven’t fully got comfortable with it.
