<?php
mysql_connect('localhost','admission2014','admission2014sgvu');
mysql_select_db("sgvuadmission");
?>

<table width="3000" cellpadding="0" cellspacing="0" border="1">
<tr><td>S.No.</td><td>ref id</td><td>fathers_name</td><td>mothers_name</td><td>local_guardion</td><td>relationship</td><td>occupation</td><td>f_desig</td><td>annul_income</td><td>f_office_address</td><td>led_number</td><td>mobile_nu</td><td>parents_emailid</td><td>std_code</td><td>m_occupation</td><td>m_desig</td><td>m_office_address</td><td>m_annual_income</td><td>m_mobile</td><td>m_email</td><td>ov_local_guar</td><td>ov_relationship</td><td>ov_mobile_no</td><td>ov_email</td><td>ov_std_code</td><td>ov_phone_number</td><td>ov_localaddress</td><td>ov_localaddress_one</td><td>ov_localaddress_one</td><td>ov_local_state</td><td>ov_localdist</td><td>ov_local_pincode</td><td>Father_lno</td><td>Father_mobno</td></tr>
<?php
$GetList=mysql_query("SELECT * FROM  `student_registration`  WHERE  `step` =  '11' AND  `sesion` =9");
while($GetList1=mysql_fetch_assoc($GetList))
{
$s =$_REQUEST['v'];

						$u = $s+0;	
			$GetChkForm=mysql_query("SELECT * FROM  `only_sid` WHERE  `sid` ='$GetList1[sid]'");
			$GetChkForm1=mysql_num_rows($GetChkForm);
			if($GetChkForm1 > 0)
			{
			
	$GetPersonal=mysql_query("SELECT * FROM  `step1_perosonal` WHERE  `sid` =  '$GetList1[sid]'");
$GetPersonal1=mysql_fetch_assoc($GetPersonal);

$GetContact=mysql_query("SELECT * FROM  `step1_contact` WHERE  `sid` ='$GetList1[sid]'");
$GetContact1=mysql_fetch_assoc($GetContact);

//$GetChk=mysql_query("SELECT * FROM  `sgvu_stu_sem_allocate` WHERE  `sid` ='$GetList1[sid]'");
//$GetChk1=mysql_fetch_assoc($GetChk);
//if($GetChk1['sem'] =='1')
{
?>
<tr><td><?php echo $_REQUEST['v'] = $u+1; ?></td><td><?php echo $GetList1['sid']; ?></td><td><?php echo $GetPersonal1['father_name']; ?></td><td><?php echo $GetPersonal1['mother_name']; ?></td><td></td><td></td><td></td><td><?php echo $GetPersonal1['father_occupation']; ?></td><td><?php echo $GetPersonal1['father_anuual_income']; ?></td><td></td><td></td><td><?php echo $GetContact1['parent_mobile']; ?></td><td><?php echo $GetContact1['parent_email']; ?></td><td>&nbsp;</td><td><?php echo $GetPersonal1['mother_occupation']; ?></td><td></td><td></td><td><?php echo $GetPersonal1['mother_income']; ?></td><td></td><td></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td><?php echo $GetContact1['parent_mobile']; ?></td></tr>
<?php

}
}

}
?>

</table>