Forums

This topic is locked

help with navigation via pop-upmenu DWMX-php-MySQL

Posted 07 Mar 2003 10:09:27
1
has voted
07 Mar 2003 10:09:27 Rob Spoelstra posted:
HI,
As a newbie I'm trying to make my first site with DreamweaverMX, php and MySQL.

My problem is that I want to pass the value of a variable via a pop-up menu (JS-behavior) to change the title and the content dynamically in two layoutcells on the same page.

In MySQL I have a database called E_Interface with one table and three colums: txtID_int (prim. key), title_int, content_int. The query in the recordset is:
SELECT * FROM e_interface WHERE e_interface.txtID_int = colname.
As a variable I have set:
(NAME)colname (DEFAULT VALUE) 1 (RUN-TIME VALUE) $HTTP_GET_VARS['txtID_int'].
When I test the query I get the right row out of the database.

I can't get the right statement in the pop-up menu. Should I work with an intermediate file or script?
Could someone please give me a clue, a statement, a script or something?

Thanks


Edited by - robspoelstra on 07 Mar 2003 14:05:25

Reply to this topic