Hi every one. i am facing issue regarding displaying Product by category wise. i have two table 1st, product category and 2nd product details. i have foriegn in second table. i am attaching three file 1st template so you can undersatnd what i am tring to do and other files are tables pictures to show you my database scema. Help me to achieve my target.

Recommended Answers

Just write a query that joins both tables. Something like:

SELECT * FROM product_categories c, products p WHERE c.id = p.category_id
Jump to Post

All 4 Replies

Just write a query that joins both tables. Something like:

SELECT * FROM product_categories c, products p WHERE c.id = p.category_id

than how i can display these product separatly as shown in the template. H2 heading contain Category and below them category wise products

Use an ORDER BY in your query and do the rest in PHP.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.