Populate dropdown box with selected value

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I am redoing a page in my module called editsubunit.

I have a table called milpacs_units with the following

unit_id,
unit_name,

I have another table called milpacs_subunits with the following

subunit_id,
subunit_name
unit_id

The unit_id's in the units table are the "parents" of the subunits. Each subunit must be assigned to a parent.

When I edit the values in subunit I want to either change the name of subunit_name or change which unit_id it is assigned to. I need a drop down box to display the current unit_name the subunit is assigned and will let me choose any other unit_name that exist in the milpacs_units table. The unit_id is stored in the subunits table for this.

This doesn't yet work, and my logic is wrong for this, but I think I am close. I also want validation so the subunit_name is not empty but I have yet to code this.

Code:

//  Update values in subunit table


if ($op == "SaveSubUnit") {      


      $sql = "UPDATE " . $prefix . "_milpacs_subunit SET subunit_name = '$subunit_name', unit_id = '$unit_id'  WHERE subunit_id ='$id'";


      $result = $db->sql_query($sql);      


      if (!$result) {


      echo("<p>Error performing query: " . mysql_error() . "</p>");


      exit();      


   }


}


      


// Display page with values from the subunit table


$id = intval($_GET['id']);


$result = $db->sql_query("SELECT msu.subunit_id, msu.subunit_name, mu.unit_name FROM " . $prefix . "_milpacs_subunit msu JOIN " . $prefix . "_milpacs_units mu WHERE msu.subunit_id ='$id' AND msu.unit_id = mu.unit_id ORDER BY msu.subunit_id");


$info = $db->sql_fetchrow($result);


if (!$result) {


    echo("<p>Error performing query: " . mysql_error() . "</p>");


    exit();


   } else {


      $subunit_name = $info[subunit_name];


      $unit_name = $info[unit_name];


   }





OpenTable();


//-- Display Form --


echo "<p><a href=\"admin.php?op=milpacs\">Return to Main Administration</a></p>"


   ."<form name=\"editsubunit\" action=\"".$admin_file.".php\" method=\"post\">"


   ." <table border=\"2\" cellpadding=\"2\" align=\"center\" cellspacing=\"0\" style=\"border-collapse: collapse;\" bgcolor=\"#000000\" bordercolor=\"#111111\" width=\"100%\">"


   ."<tr>"


   ."<td align=\"center\" bgcolor=\"#777777\">Sub Unit of " 


   /******* Begin Unit Select Box ********/


   ."<select name=\"unit_name\">";


   $sql2 = "SELECT unit_id, unit_name FROM " . $prefix . "_milpacs_units mu, " . $prefix . "_milpacs_subunits msu WHERE mu.unit_id = msu.unit_id ORDER BY mu.unit_order";


   $result2 = $db->sql_query($sql2);


   while(list($unit_id, $unit_name) = sql_fetchrow($result2) ) {


    $selected = "";


    if ($row2['unit_id'] == $unit_id) { $selected = "selected"; }


    echo "<option value=\"$unit_id\">$unit_name</option>\n";  


   echo "</select>\n"; 


   /******* End Unit Select Box ********/


   }


   echo"</td>"


    ."</tr>"


    ."<td align=\"center\" bgcolor=\"#777777\"> Sub Unit Name <input type=\"text\" name=\"subunit_name\" value=\"$subunit_name>"


    ."</td>"      


   ."</tr>"


   ."</table>"


   ."<br>"


   ."<input type=\"hidden\" name=\"op\" value=\"SaveSubUnit\"/>"


   ."<input type=\"hidden\" name=\"id\" value=\"$id\">"


   ."<input type=\"submit\" align=\"center\" name=\"Submit\" value=\"Update\"/>"


   ."</form>";


CloseTable();


@include_once("footer.php");


?>

registered · Posted: Sat Mar 04, 2006 6:53 am

Actually, I would recommend just adding another input field for the subunit name. This way, your page would have the ability to both change the subunit name and also to then pick the unit that subunit reports to.