I am trying to develop a query which is generated based on the choices a user makes in 5 page multipage form:
www.mindseyemidlands.co.uk/notts_quality/info_resource/non_quality_1.php
The user choices are stored in a table called user_quality and then compared to another table called quality_info to see if a tick in a checkbox/radiobutton matches up. If there is a corresponding tick then the record will be echoed as this corresponds to a choice the user has made. My question is is there a quick and efficient way to run through each corresponding field to check out for matches instead of a long winded 'and if' approach? Here are my tables designs:
www.mindseyemidlands.co.uk/notts_quality/info_resource/quality_info_table.txt
www.mindseyemidlands.co.uk/notts_quality/info_resource/user_quality_table.txt
thx in advance
