One more for the night

I promise, this is the last one tonight :) I want to be able to pull up all the items for navigation on the left menu, then each item might have a sub item underneath it, but I only want to call them when you are on that section. The code is below. Example, when you first hit the page you will see 5 sections on the left, clicking one of them will open that page and the SUB pages under it. So, you would see Alex Scott David On the first page, click Alex and you would see: Alex

     Erin

Scott David <? $connection = mssql_connect("parks2","sa",""); $db = mssql_select_db("wmn_test",$connection); $sql = "select bp_section_id,bp_section_name from bp_sections order by bp_section_name"; $sql_result = mssql_query($sql); while ($row = mssql_fetch_array($sql_result)){ $bp_section_id = $row["bp_section_id"]; $bp_section_name = $row["bp_section_name"]; $ln = "<tr><td><a href=\"bpsection.php?section=$bp_section_id\">$bp_section_name</a></td></tr>"; $new_data[] = $ln; }; $sqlsub = "select bps_section_id,bps_section_name from bp_sub_sections where fk_section_id ='$sectionid'"; $sql2_result = mssql_query($sqlsub); while ($row = mssql_fetch_array($sql2_result)){ $bps_section_id = $row["bps_section_id"]; $bps_section_name = $row["bps_section_name"]; $ln = "<tr><td><a href=\"bpsection.php?section=$bps_section_id\">$bps_section_name</a></td></tr>"; $new_data3[] = $ln; }; $displn1 = implode("",$new_data); $displn2 = implode("",$new_data3); $displn = ("$displn1,$displn2"); $connection = mssql_connect("parks2","sa","90Pitt!!"); $db = mssql_select_db("wmn_test",$connection); $sql = "select template_content from bp_sections inner join bp_templates on template_id = bp_sections.fk_template_id where bp_section_id = '$sectionid'"; $sql_result = mssql_query($sql); ($row = mssql_fetch_array($sql_result)); $template = $row["template_content"]; $temp = str_replace("[LEFT NAV]",$displn,$template); $temp2 = str_replace("[GRAPHIC HEADER]",$graphic_header,$temp); $temp3 = str_replace("[RIGHT CONTENT]",$right_content,$temp2); $temp4 = str_replace("[BODY GRAPHIC]",$body_graphic,$temp3); $temp5 = str_replace("[BODY DATA]",$body,$temp4); echo $temp5; ?>