are there any guides to creating a dynamic menu from mysql data?

[Wayne...]

I'd like to create a menu system thats dynamic in nature and pulls the page
id ,name, title etc from a mysql table so that when a page is added it will
be automatically linked into the menu system.
are there any guides out there about this?
Thanks in advance.

Wayne...

[AnteD]

Well this is my db for dynamic menues....I've seen this stucture in many
books and articles....

menu_id INT
parent_id INT DEFAULT '0'
name VARCHAR(255) DEFAULT ''
description TEXT
location VARCHAR(255) DEFAULT ''

all keys are NOT NULL where menu_id is PrimaryKey and location is
UniqueKey...

Hope this helps.....


<Michael Vilain <vilain@spamcop.net>> wrote in message
news:vilain-F0D1F0.20232520062004@comcast.dca.giganews.com...

> In article <40d5e045@212.67.96.135>,
> "Wayne..." <wayne@secretwebdesign.com> wrote:
>

> > I'd like to create a menu system thats dynamic in nature and pulls the

page

> > id ,name, title etc from a mysql table so that when a page is added it

will

> > be automatically linked into the menu system.
> > are there any guides out there about this?
> > Thanks in advance.
> >
> > Wayne...

>
> Sounds like a SOP--simple matter of Programming. Try some basic PHP
> books that include MySQL. The menu would be built by a query, then
> displayed.
>
> --
> DeeDee, don't press that button! DeeDee! NO! Dee...
>
>
>

[Duncan Austin]

Hi,

Check zend.com under [developers]->[code gallery]. They've got some good
ones

Duncan

On Mon, 21 Jun 2004 14:30:14 +0200, AnteD <ante{at]abstraktmedia[.}com>
wrote:

> Well this is my db for dynamic menues....I've seen this stucture in many
> books and articles....
>
> menu_id INT
> parent_id INT DEFAULT '0'
> name VARCHAR(255) DEFAULT ''
> description TEXT
> location VARCHAR(255) DEFAULT ''
>
> all keys are NOT NULL where menu_id is PrimaryKey and location is
> UniqueKey...
>
> Hope this helps.....
>
>
> <Michael Vilain <vilain@spamcop.net>> wrote in message
> news:vilain-F0D1F0.20232520062004@comcast.dca.giganews.com...

>> In article <40d5e045@212.67.96.135>,
>> "Wayne..." <wayne@secretwebdesign.com> wrote:
>>

>> > I'd like to create a menu system thats dynamic in nature and pulls the

> page

>> > id ,name, title etc from a mysql table so that when a page is added it

> will

>> > be automatically linked into the menu system.
>> > are there any guides out there about this?
>> > Thanks in advance.
>> >
>> > Wayne...

>>
>> Sounds like a SOP--simple matter of Programming. Try some basic PHP
>> books that include MySQL. The menu would be built by a query, then
>> displayed.
>>
>> --
>> DeeDee, don't press that button! DeeDee! NO! Dee...
>>
>>
>>

>
>

--
Duncan

[Wayne...]

thanks

Wayne...