/home/mip/public_html_/old_mip/sqloptions.php
<?php
session_start();
require_once("func_proc.php");
require_once("func_select.php");
require_once("func_select_codes.php");
switch($what){
/* -------------------------- ajax load on select box -------------------------- */
case 'load_category1':
$positions = getdata("select * from positions where category_id='$category_id' and category_id <> '0' order by name");
$num_positions = count($positions);
?>
var positions = document.thisonly2.position1;
positions.options.length = 0;
positions.options[positions.options.length] = new Option('','');
<?
for ($i=1; $i<=$num_positions; $i++) { ?>
positions.options[positions.options.length] = new Option('<?=$positions[$i][name]?>','<?=$positions[$i][position_id]?>');
<? }
break;
case 'load_category2':
$positions = getdata("select * from positions where category_id='$category_id' and category_id <> '0' order by name");
$num_positions = count($positions);
?>
var positions = document.thisonly.position1;
positions.options.length = 0;
positions.options[positions.options.length] = new Option('','');
<?
for ($i=1; $i<=$num_positions; $i++) { ?>
positions.options[positions.options.length] = new Option('<?=$positions[$i][name]?>','<?=$positions[$i][position_id]?>');
<? }
break;
}
?>