Creating database driven navigation

[technoplonker]

I am trying to create a web page which has navigation that is both
edited and generated via a database.

I have been able to create a table that displays the navigation
subject headers and sub-menu titles. I would like to now integrate
this dynamism with a javascript menu. The problem is thatthe table was
generated by displying the database table column headings first and
then the table cell values.

Instead I would like to be able to have each column heading displayed
then the cell values straight after. And so on for each column in the
table.

I'm sorry if this is not very clear but it's the clearest descrition I
can give.

Thanks in advance.

TP

[Aaron Bertrand - MVP]

Why don't you show us you database structure, and mock up some hard-coded
HTML that represents how the menu should look when it's done.

Narrative is pretty useless on its own.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"technoplonker" <webmaster@webteq.net> wrote in message
news:d3402cc5.0401070803.734dcb59@posting.google.c om...

> I am trying to create a web page which has navigation that is both
> edited and generated via a database.
>
> I have been able to create a table that displays the navigation
> subject headers and sub-menu titles. I would like to now integrate
> this dynamism with a javascript menu. The problem is thatthe table was
> generated by displying the database table column headings first and
> then the table cell values.
>
> Instead I would like to be able to have each column heading displayed
> then the cell values straight after. And so on for each column in the
> table.
>
> I'm sorry if this is not very clear but it's the clearest descrition I
> can give.
>
> Thanks in advance.
>
> TP

[Jeff Cochran]

On 7 Jan 2004 08:03:26 -0800, [email]webmaster@webteq.net[/email] (technoplonker)
wrote:

>I am trying to create a web page which has navigation that is both
>edited and generated via a database.
>
>I have been able to create a table that displays the navigation
>subject headers and sub-menu titles. I would like to now integrate
>this dynamism with a javascript menu. The problem is thatthe table was
>generated by displying the database table column headings first and
>then the table cell values.

>Instead I would like to be able to have each column heading displayed
>then the cell values straight after. And so on for each column in the
>table.
>
>I'm sorry if this is not very clear but it's the clearest descrition I
>can give.

It would help if we knew the database structure, or if you had encoded
any type of navigation or location information in it. Maybe category,
subcategory, or something similar.

Jeff

[technoplonker]

The database structure is roughly like this.

Table 1 - Configuration

This table has Fields which hold data such as the admin user name and
password and various other configuration info for the look of the
page.

Table 2 - Site Data

This table consists of three Fields, Name, Description and ID

Table 3 - Navigation

This is the table in question. It is intended it to have as many
Fields as are required. With as many Values for each Field as
required. Though not all fields will have equal amounts of values.

The Navigation method being used is here
[url]http://www.dynamicdrive.com/dynamicindex1/switchmenu.htm[/url]

The Data manipulation code was obtained from the following FAQ
[url]http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=44[/url]

I would like for the code to iterate over each Field one at a time,
displaying first the name for each then the Values for each before
moving on to the next Field.

I thought that perhaps I could use a temprorary variable but the logic
escapes me. The Db is Access 2000