Dreamweaver - sql query in dreamweaver

Author

sql query in dreamweaver

iberican

2004-08-21, 11:14 pm

helle,
i've a problem.
i've a PHP site which is connected to an mysql database.
this site contains a dynamic menu on the left which gets its data from an
table out of the database (10 entries or s.th like that) and on the right a
layout table which ought to get the data from another table of the database.
this also works, but only for the first link in the menu.
every entry in the menu is a link to another table in the database. the
problem is that the second entry in the menu schould link to the second entry
of the table with the contents. this doesnt work.

i made this link by : properties -->hyperlink>chose a file-->
parameter-->name: chose the table with the menu entries; value: chose the
first field of the content table.
this is how it works for one link but in the next step i cant select the
second entry in the content table for the second link.

how can i make that in dw?

best regard

Jeff North

2004-08-21, 11:14 pm

On Sat, 21 Aug 2004 22:22:40 +0000 (UTC), in macromedia.dreamweaver
"iberican" <webforumsuser@macromedia.com> wrote:

>| helle,
>| i've a problem.
>| i've a PHP site which is connected to an mysql database.
>| this site contains a dynamic menu on the left which gets its data from an
>| table out of the database (10 entries or s.th like that) and on the right a
>| layout table which ought to get the data from another table of the database.
>| this also works, but only for the first link in the menu.
>| every entry in the menu is a link to another table in the database. the
>| problem is that the second entry in the menu schould link to the second entry
>| of the table with the contents. this doesnt work.
>|
>| i made this link by : properties -->hyperlink>chose a file-->
>| parameter-->name: chose the table with the menu entries; value: chose the
>| first field of the content table.
>| this is how it works for one link but in the next step i cant select the
>| second entry in the content table for the second link.
>|
>| how can i make that in dw?

Need more information. Please post the sql statement and the table
structure.

---------------------------------------------------------------
jnorth@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------