php mysql 过滤,PHP-按MySQL字段值过滤

I've got a table with some rows that contain 3 fields (category, title, image). At first I created a foreach loop that returned some html with the information from each of the rows. However, now I actually want to create a scenario where I can "filter" my loop by category.

What I mean to say is that I want to create a function that will only generate the html for rows that have a particular value for their category field. I want to be able to apply this function to all the different values for category.

Any help would be appreciated.

解决方案

MySql query solution:

Use a Where Statement in your query, and keep your PHP the same.

e.g.

Select * From table Where `category`="Filter Value";

Let me know if that works for you, or if you're constrained to only using PHP to filter the category..