<?php

require "config.php"; // database connection details 
echo "

function fillQualification(){ 
 // this function is used to fill the Qualification list on load

";

$q1=mysql_query("select * from qualification");
echo mysql_error();
while($nt1=mysql_fetch_array($q1)){
echo "addOption(document.form1.Qualification, '$nt1[QualificationId]', '$nt1[QualificationName]');";
}// end of while
?>
} // end of JS function

function SelectSpecial(){
// ON or after selection of qualification this function will work

removeAllOptions(document.form1.Specialization);
addOption(document.form1.Specialization, "", "-Select-", "");

// Collect all element of Specialization for various QualificationId 

<?php 
// let us collect all QualificationId and then collect all Specialization for each QualificationId
$q2=mysql_query("select distinct(QualificationId)  from specialization");
// In the above query you can collect QualificationId from qualification table also. 
while($nt2=mysql_fetch_array($q2)){
echo "if(document.form1.Qualification.value == '$nt2[QualificationId]'){";
$q3=mysql_query("select SpecializationArea from specialization where QualificationId='$nt2[QualificationId]'");
while($nt3=mysql_fetch_array($q3)){
echo "addOption(document.form1.Specialization,'$nt3[SpecializationId]', '$nt3[SpecializationArea]');";


} // end of while loop
echo "}"; // end of JS if condition

}
?>
}



function removeAllOptions(selectbox)
{
	var i;
	for(i=selectbox.options.length-1;i>=0;i--)
	{
		
		selectbox.remove(i);
	}
}


function addOption(selectbox, value, text )
{
	var optn = document.createElement("OPTION");
	optn.text = text;
	optn.value = value;

	selectbox.options.add(optn);
}