How to build (unlimited categories)?

[web_designer_iq]

Hi,
I want to build unlimited categories , I use the following MySQL table :
cat_id : The number of category
title: The title of category
subcat: 0 mean it's not sub category, and a number for sub.

1) I want to show all categories and sub categories with once query!
2) I want to show all categories and sub categories for specific article
for example:

PHPBuilder.com > PHP Help > Database > How to build table.

Thanks 🙂

[Roger_Ramjet]

this is called hierarchical data and the best thing for you to do is to read this article . It gives table design and queries that you will need.