Hi every one
I need to retrieve categories and subcategories by category type this my data
category_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
category_parent INT(11) UNSIGNED NOT NULL DEFAULT '0',
category_name VARCHAR(255) NOT NULL DEFAULT '',
category_type VARCHAR(30) NOT NULL DEFAULT 'news',
like
News++++++
category1
category2
subcategory1
Video++++++
category3
category4
category5
something like that
thank you