dynaic menu

message from jjrmy1 on 19 Jul 2004
i have a menu box and all the values in it are dynamically selected from an access table. well i want to make the default value to
be something that's in another table. anyone know of a good tut for this?
thanks
 
Craig replied to jjrmy1 on 20 Jul 2004
do you mean where one data1.column1 = data2.column1 (another table), or the
first item is selected?

if the first item in the list, look at the code view for yr menu. See the
<option value=""></option> section.
Type in another one, from yr Server bindings panel drag the appropriate
column names onto the page
<option value="<?php echo $row_rsYear['yearID']; ?>"><?php echo
$row_rsYear['year']; ?></option>

To make an item selected based on equal values, when you click the 'dynamic
data' button for a menu it opens the selection window for the dynamic data,
at the bottom of which is a link (the lightening bolt), this link allows you
to select the column from a 2nd table on which value you will compare
<option value="<?php echo $row_rsTheme['ptheme_id']?>"<?php if
(!(strcmp($row_rsTheme['ptheme_id'], $row_rsCat['pcat_id']))) {echo
"SELECTED";} ?>><?php echo $row_rsTheme['theme']?></option>

Craig

"jjrmy1" <jjrmy1@earthlink.net> wrote in message
news:cdhgaa$nab$1@forums.macromedia.com...
an access table. well i want to make the default value to
 

Archived message: dynaic menu (Macromedia Dreamweaver Web Design)