I am trying to finish this project where the user can select a color from a dropdown list and then press the filter button. Once they press the filter button the view changes so the page refreshes and only shows pictures with those colors. I need to do this by finding the matching color ID from the database to the user-selected color from the dropdown menu.
Here is the dropdown menu I am using
![[Image: Xg0CUCg.png]](https://i.imgur.com/Xg0CUCg.png)
Here is my code I have so far that does not work. When I hit the filter button the page refreshes but it is exactly the same and shows all the same pictures as before instead of just one color. I think I am either missing something or going wrong in my query to the database. the variable uColor is set up to get the user selection from the dropdown menu.
![[Image: qb6iU1A.png]](https://i.imgur.com/qb6iU1A.png)
Any help would be appreciated.
Here is the dropdown menu I am using
![[Image: Xg0CUCg.png]](https://i.imgur.com/Xg0CUCg.png)
Here is my code I have so far that does not work. When I hit the filter button the page refreshes but it is exactly the same and shows all the same pictures as before instead of just one color. I think I am either missing something or going wrong in my query to the database. the variable uColor is set up to get the user selection from the dropdown menu.
![[Image: qb6iU1A.png]](https://i.imgur.com/qb6iU1A.png)
Any help would be appreciated.


![[Image: jake-johnson-hf-sig.png]](https://i.ibb.co/4V9R06r/jake-johnson-hf-sig.png)
