<script language="JavaScript">

function office_names() {

var select = document.form.office_name;
select.options[0] = new Option("Choose One");
select.options[0].value = '';

<?php

@$office_name = $_GET['officename'];

$query = "select * from ".$db_prefix."offices";
$result = mysql_query($query);

$cnt=1;
while ($row=mysql_fetch_array($result)) {
  if (isset($abc)) {
  echo "select.options[$cnt] = new Option(\"".$row['officename']."\");\n";
  echo "select.options[$cnt].value = \"".$row['officename']."\";\n";
  } elseif ("".$row['officename']."" == stripslashes($office_name)) {
  echo "select.options[$cnt] = new Option(\"".$row['officename']."\",\"".$row['officename']."\", true, true);\n";
  } else {
  echo "select.options[$cnt] = new Option(\"".$row['officename']."\");\n";
  echo "select.options[$cnt].value = \"".$row['officename']."\";\n";
  }
  $cnt++;
}
mysql_free_result($result);
?>
}

function group_names() {
var offices_select = document.form.office_name;
var groups_select = document.form.group_name;
groups_select.options[0] = new Option("Choose One");
groups_select.options[0].value = '';

if (offices_select.options[offices_select.selectedIndex].value != '') {
  groups_select.length = 0;
}

<?php

$query = "select * from ".$db_prefix."offices";
$result = mysql_query($query);

while ($row=mysql_fetch_array($result)) {
$office_row = addslashes("".$row['officename']."");
?>

if (offices_select.options[offices_select.selectedIndex].text == "<?php echo $office_row; ?>") {
<?php
$query2 = "select * from ".$db_prefix."offices, ".$db_prefix."groups where ".$db_prefix."groups.officeid = ".$db_prefix."offices.officeid 
           and ".$db_prefix."offices.officename = '".$office_row."'";
$result2 = mysql_query($query2);
echo "groups_select.options[0] = new Option(\"...\");\n";
echo "groups_select.options[0].value = '';\n";
$cnt = 1;

while ($row2=mysql_fetch_array($result2)) {
  $groups = "".$row2['groupname']."";
  echo "groups_select.options[$cnt] = new Option(\"$groups\");\n";
  echo "groups_select.options[$cnt].value = \"$groups\";\n";
  $cnt++;
}

?>
}
<?php
}
mysql_free_result($result);
mysql_free_result($result2);
?>

if (groups_select.options[groups_select.selectedIndex].value != '') {
  groups_select.length = 0;
}
}

</script>