Posted by Rik Wasmus on 08/31/07 10:04

On Fri, 31 Aug 2007 11:56:07 +0200, php_mysql_beginer911 =

<deepakgc@gmail.com> wrote:

> Hi am not very good in php so looking for someone who could give some
> suggections ...
>
> i am trying to make a Menu where i can make Sub Menu and also i can
> make any number of sub Menu under any Sub Menu ..
>
> If i have only one level Menu And Sub Menu-- i can make a table with
> id and parent id where parent id will be the Menu id for Sub Menu that=

> means ID And PARENT_ID fields are important but if make multiple sub
> menus of ny number how i will change my table structure
>
> Menu ->Sub_Menu-> Sub_Menu
>
> to get sub menu query will be like "select * from table_menu where
> parent_id=3Dmenu_id"
>
> but to get any sub menu whihc is under any sub menu how it will go
>
> i am not sure if i am able to make it clear here
>
> but if somebody understand what i am trying to explaing please suggest=

> anything

Some reading material:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

-- =

Rik Wasmus

My new ISP's newsserver sucks. Anyone recommend a good one? Paying for =

quality is certainly an option.

[Back to original message]