Update one select box with another select box.

[techniq]

I'm generating two select statments via the ADOdb GetMenu() func. and a SQL query. I would to like filter the contents of the second select statement based on the selection made in the first select statement. I assumed Javascript would be the choice but was having trouble doing this seeing as though I need to re-run the SQL query with a added 'WHERE' clause containing the choice of the first select statement.

The two queries are to the same sql table. Can anyone provide a direction to go with this one or example code if you've done something similiar?

Thanks.

[jeremuck]

what's your current source code look like?
do you have some mock code to show us?

So... before anything is printed on the screen, you want to run two queries to the db, the second of which relies on the first's results?

[techniq]

the is a query page. When it first comes up the two select fields will be populated with everything and the default option on each is blank. If you choose an item in the first select box the second one updates to reflect the first.

So select box #1 is categoryA and select box #2 is sub-categoryA.

the mock code looks like this...it is just a piece of a larger table...but these are two select boxes I'm referring. You can see that first select statement generated by GetMenu() can take a ONCHANGE javascript and run through a javascript func., but since I can't put PHP in the javascript func I'm not sure how to re-run the query.

<?php

<TR><!--Row 4-->
     <TD WIDTH="50%" ALIGN="CENTER"><!--Document 1-->
          <TABLE WIDTH="100%" border="0" cellspacing="3">
           <TR>
             <TD ALIGN="CENTER" CLASS="metatitle"><B><FONT COLOR="#FFFFFF">Module Group Name</FONT></B></TD>
             <BR>
           </TR>
           <TR>
             <TD WIDTH="50%" ALIGN="CENTER">';
                 $dbconn->Connect($SNPro_server, $SNPro_user, $SNPro_pass, $SNPro_db);
                 $sSQL_mod_grp = 'select distinct module_group_name from event';
                 $module_grp = $dbconn->Execute($sSQL_mod_grp);
                 print $module_grp->GetMenu('module_grp','module_group_name',true,false,0,'ONCHANGE="update_module_sig()" ');
                 $dbconn->Close();
		echo '              		 
             </TD>
           </TR>
          </TABLE>
     </TD>

 <TD WIDTH="50%" ALIGN="CENTER"><!--Document 1-->
      <TABLE WIDTH="100%" border="0" cellspacing="3">
       <TR>
         <TD ALIGN="CENTER" CLASS="metatitle"><B><FONT COLOR="#FFFFFF">Module (Sig) Name</FONT></B></TD>
         <BR>
       </TR>
       <TR>
         <TD WIDTH="50%" ALIGN="CENTER">';
             $dbconn->Connect($SNPro_server, $SNPro_user, $SNPro_pass, $SNPro_db);
             $sSQL_mod_sig = 'select distinct module_name from event';
             $module_sig = $dbconn->Execute($sSQL_mod_sig);
             print $module_sig->GetMenu('module_sig','module_name',true,false,0);
             $dbconn->Close();
	echo '
 		</TD>
       </TR>
      </TABLE>
 </TD>     
</TR>

?>

[Sxooter]

Did anyone look into the snippet library here on PHP Builder?

http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=491

[techniq]

This actually isn't well suited for my code. His example code uses the javascript to generate the options, whereas mine are generated dynamically by the ADOdb GetMenu() func. I would like to keep the ADOdb GetMenu() func as it is very clean code. If anyone feels there is no other option than the code that is in the library let me know and I will abandon the ADOdb stuff.

Clean code Example (this is all it takes to generate a select list with the ADOdb GetMenu() func.):

[...SNIP...]

<?php
$dbconn->Connect($SNPro_server, $SNPro_user, $SNPro_pass, $SNPro_db);
                 $sSQL_mod_sig = 'select distinct module_name from event';
                 $module_sig = $dbconn->Execute($sSQL_mod_sig);
                 print $module_sig->GetMenu('module_sig','module_name',true,false,0);
                 $dbconn->Close();
?>

[...SNIP...]

Thanks!

[[deleted]]

Someone posted a tidy little script on this forum a few weeks ago re: dynamic select boxes. Selecting one option determines the options in the second drop down box.

Check this thread...

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10211734&highlight=dynamic+drop+down