Retrieving categories an sub categories in parent to child order

Asked Apr 06 '17 at 06:08

Active Apr 06 '17 at 06:08

Viewed 34 times

I have following Table i want

 id | item_name  | parent_id | 
 1  | Shoes      | 0         | 
 2  | Jackets    | 0         | 
 3  | Formal     | 1         | 
 4  | Casuals    | 1         | 
 5  | Party Wear | 2         | 
 6  | Leather    | 5         | 
 7  | Imported   | 6         |

Now i want when i run query to get all cateogries of "Jackets" result should be like this

Jackets,Party wear,Leather,Imported|

asked Apr 06 '17 at 06:08

Umer iqbal

what you have *tried* ? Can you show us something ? – Mittul At TechnoBrave Apr 06 '17 at 06:09
use group by parent_id. – Afshan Shujat Apr 06 '17 at 06:10
@AfshanShujat using group by will return only one record for parent id 1 i.e either formal or casual – Purushottam zende Apr 06 '17 at 06:12
Google hierarchical query MySQL – Tim Biegeleisen Apr 06 '17 at 06:13
@Umer iqbal In SO you won't get that you want until you did not try yourself something, show us what you have tried ? – lazyCoder Apr 06 '17 at 06:16
Possible duplicate of [Hierarchical queries in MySQL](http://stackoverflow.com/questions/8104187/hierarchical-queries-in-mysql) – dsharew Apr 06 '17 at 06:16
Suggestion: Use `order by` with `desc` or `asc` with `parent_id` – Mittul At TechnoBrave Apr 06 '17 at 06:18
For this result you have to write MySQL store procedure. I think better that you have write code in php – Gaurav Apr 06 '17 at 06:44
SELECT c.name FROM categories c join categories a on c.id=a.subcategory where c.id='2' order by a.subcategory desc – Umer iqbal Apr 06 '17 at 06:46
SELECT c.item_name FROM categories c join categories a on c.id=a.parent_id where c.id='2' order by a.parent_id desc – Umer iqbal Apr 06 '17 at 06:51

Retrieving categories an sub categories in parent to child order

0 Answers0