<?php
$mylink=mysql_connect($dbhost,$dbuser,$dbpasswd);
mysql_select_db($dbname,$mylink);
$sql="select * from itocean_info_nsub order by sid";
$result=mysql_query($sql);
?>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<?php
$count = 0;
while($myarray=mysql_fetch_array($result))
{
?>
subcat[<?php echo $count; ?>] = new Array("<?php echo $myarray["nsub"];?>","<?php echo $myarray["nclassid"];?>","<?php echo $myarray["sid"];?>");
<?php
$count=$count+1;
}
?>
onecount=<?php echo $count ?>;
function changelocation(locationid)
{
document.form1.sid.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{ //
document.form1.sid.options[document.form1.sid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}