/home/mip/public_html_/old-website/employer/sqloptions.php
<?php
session_start();
require_once("func_all.php");

switch($what){

/* -------------------------- ajax load on select box -------------------------- */		
case 'load_category_source':	
	
	$positions = getdata("select * from positions where category_id='$category_id' order by name");
	$num_positions = count($positions); 
	?>	
	var positions = document.forms[0].position_id;
	positions.options.length = 0;
	positions.options[positions.options.length] = new Option('All','');
	<?
	for ($i=1; $i<=$num_positions; $i++) {  ?>
		positions.options[positions.options.length] = new Option('<?=$positions[$i][name]?>','<?=$positions[$i][position_id]?>');
	<? }

	break;
	
case 'load_position':	
	
	$positions = getdata("select jo.jo_pos_id, pos.name from jo_position as jo, positions as pos where 1 and jo.position_id = pos.position_id and  jo.job_order_id='$job_order_id' order by pos.name");
	$num_positions = count($positions); 
	?>	
	var positions = document.forms[0].jo_pos_id;
	positions.options.length = 0;
	positions.options[positions.options.length] = new Option('All','');
	<?
	for ($i=1; $i<=$num_positions; $i++) {  ?>
		positions.options[positions.options.length] = new Option('<?=$positions[$i][name]?>','<?=$positions[$i][jo_pos_id]?>');
	<? }

	break;
		
}
?>