# Muiltple MySQL joins form checkbox array

**URL:** <https://forum.kirupa.com/t/muiltple-mysql-joins-form-checkbox-array/238276>\
**Category:** Uncategorized\
**Created:** [September 9, 2007, 10:52am UTC](https://forum.kirupa.com/t/muiltple-mysql-joins-form-checkbox-array/238276 "2007-09-09T10:52:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 9, 2007, 10:52am UTC](https://forum.kirupa.com/t/muiltple-mysql-joins-form-checkbox-array/238276/1 "2007-09-09T10:52:59Z")

</div>

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.

🙂