Hi, I've been working on this website:
As you can see on the website there are 3 menus. The idea is for one item on each menu to stay highlighted in order to filter down results. So if 'Art', 'A', and 'Most Recent' were highlighted, then the SQL query would get results that have 'art' as their subject and of them, only the results beginning with 'A'. They would then be ordered by date (most recent).
Also, as a lot of the results have duplicate titles, they need to be filtered out to so that there is only ever one instance of each title.
When each button is clicked it's value is added to the URL string and then put into variables ($alphabet, $subject, $listtype)
I know that's quite a lot to ask so I'll just wait in hope. I've been trying to work it out all day and got nowhere so any pointer will be good. Someone already mentioned LEFT OUTER JOINing but I wasn't sure how to implement it.