How to create a PHP filter by criteria?

Question

PHP

Hello,
I want to create a product filter in PHP, MySQL.
There is a table with goods, and you need to take one size from a table with sizes, for example S, and from a table with colors, for example, red, and you need to display from the table with goods only those that fit these criteria and you need to do this on do, while or for.
Thank you.

Answer 1

Well, what's the problem?

Answer 2

Try to do it in PHP, though, storing data in mySQL using loops.
Not on do, while and for.