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
Jump to PostJust write a query that joins both tables. Something like:
SELECT * FROM product_categories c, products p WHERE c.id = p.category_id
All 4 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Just write a query that joins both tables. Something like:
SELECT * FROM product_categories c, products p WHERE c.id = p.category_id
aneeqtariq_143
0
Newbie Poster
than how i can display these product separatly as shown in the template. H2 heading contain Category and below them category wise products
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Use an ORDER BY in your query and do the rest in PHP.
aneeqtariq_143
0
Newbie Poster
ok Thanks. i'll try
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.