I have two diagrams and one unordered list( http://hardis.synology.me/portalen/filter.png ) that rely on select statements and I'm wondering what the best way to filter those. (one filter for all of them!)
$result = mysql_query("SELECT * FROM TABLE WHERE filterArray ORDER BY Datum_formatning ASC");
I have 5 fields that will contain the filteroptions (ever growing list) so I'm thinking a form containing all the filteroptions and a filter button as seen on the image. So the five filteroptions give 5 values going into the "filterarray"
The problem I'm having is
1. Is this really the best way to go about it?
2. The filterboxes are not very nice to look at, any theming possible?
3. I don't know to build the filterarray...
Any advice on these matters are appreciated!