Help Create sub menu from database!

[eluser]uqmeebi[/eluser]
[quote author="Krystian" date="1344857300"]you need to create table like this

id
label
parent_id


so the entries for you example would be

1 | menu_item_1 | 0 |
2 | sub 1 menu_item_1 | 1 |
3 | sub 2 menu_item_1 | 1 |
4 | sub 3 menu_item_1 | 1 |
5 | sub 4 menu_item_1 | 1 |
6 | menu_item_2 | 0 |
7 | menu_item_3 | 0 |
8 | menu_item_4 | 0 |

and you need to proper print it and style it


[/quote]


thx but i don't understand how create MODEL for query please create simple file for example.