I am trying to create an inventory using php/mysql.
However, I am using a webpage such that the viewer or user indicates or picks their choice by making continous selections on the spry menu.
For example, if the first choice is "x", another menu appears with several options and say they pick "Y". This also leads to another menu, say they pick "Z". The items "x","Y" and "Z" fall under different columns in the database table.
Is it possible to create a mysql query that picks data from the table that matches "x", "Y", "Z"?