I've looked through the forum, read countless threads and watched videos, and now have a semi-solid grasp of how the databases work. I've been playing with my site, but need some specific direction. My coding skills are limited, so I don't want to create something that I will have a disaster of a time troubleshooting if something goes awry when it's live.
My goal is to have service providers submit a portfolio (list of services, small details of service, pictures of services) and then to have visitors be able to search the results by their service type, the small details of service and to be able to sort the results. For example, a baker clicks off checkboxes indicating that they make cupcakes, wedding cakes and birthday cakes. The baker uses a dropdown to indicate that they make custom designs (yes or no). The baker also submits three photos and provides a price list. Then, visitors can hopefully click off boxes displaying all of the service providers who provide the desired service, and can narrow down those results based on other options. They could also filter those results in a few ways (distance, price, etc).
I've set up a database with the desired fields and created the portfolio submission page linked to the appropriate fields. As it's currently setup, the bakers click off boxes for the services that they provide, which uses boolean values. When I try to create a search for the results, I can't seem to find a way to display boolean data.
1. How can I search results using bolean values?
2. How do I set up a "sort" feature of the results?