[eluser]bugboy[/eluser]
Hello All
Hope your all having a great day.
I have a question and its to do with MySQL. (not my strongest point).
I need to do what seems like a simple search but for the life of me not work out what to do.
I have a table structure like this.
Code:
cms_stove
id (pk)
title
dscpn
cms_flu
id (pk)
title
dscpn
// linking table
cms_stove_flu
stove_id (fk)
flu_id (fk)
each stove thats been inputted can have more then one flu type.
I need to do a search on this so i can from a html check box list of the flu types get all the stoves without duplicates that have those flu types.
I would do a search but i don't even know where to begin on this. Any pointers or links or help would be greatly appecitated.
Thanks