I'm building a project that not only has me stumped how to code it, but to even explain it. here goes nothing... I have a vendor that needs to see one of multiple pages. The code for those pages is stored in a table and is called based on a variable. That page also has sub sections in another table that are also viewed. I have no problem getting those to pull and display, the problem lies in giving them the ability to turn subsections on or off. I have a third table that holds vendorid pageid pagedetailid and status (on or off). How do I pull the main page, then query for the detailid that matches both the pageid and status of "on", use those rows to pull the detail text and display it. What's got me is there are multiple rows in the third table and I don't know how to do a WHERE query for using multiple records as the conditional statement.
Now I've managed to confuse myself even more.
