2-2 上課範例：admin/ajax.php

<?php
include_once "header_admin.php";

$parent_gsn=empty($_POST['parent_gsn'])?0:$_POST['parent_gsn'];

echo get_cate_options($parent_gsn);


function get_cate_options($parent_gsn){
	global $xoopsDB ;
	
	$sql = "select `gsn` , `title` from `".$xoopsDB->prefix("contact_cate")."` where `parent_gsn` = '$parent_gsn' order by `sort`";
	
	$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'] , 3, mysql_error());

	$main="";
	while(list($gsn , $title)=$xoopsDB->fetchRow($result)){
		$main.="<option value='$gsn'>{$title}</option>";
	}
	return $main;
}
?>