I now have two tables, a category table and a product table. There is a field in the product table to record which category it belongs to. Now I want to display multiple categories from top to bottom on one page. Below each category Display his products. After the products are displayed, the next category is displayed. I feel that I see this often but I can’t think of how to write the SQL statement and html
