Member Avatar for developer707

Hello to everyone.
I have this table:

CREATE TABLE `documents_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `active` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

I am trying to create a qyery that gives me: (subcategory id, subcategory title, category title) The categories has the parent_id = 0

Edited by pritaeas because: Fixed markdown.
  • 2 Contributors
  • 2 Replies
  • 220 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by developer707
Member Avatar for developer707

For example if a users clicks under a submenu he will get a breadcrub like this one in the image.

Untitled.png 18.86 KB
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.