How can i get details from multiple tables for each user

Hi,

I am doing matrimony website…in tat website hav registration for user…iam using username and password for login…then they register and login to website…each user create a profile.tat table like tblprofile, tblpersonal, tblfamily,tblcontacts…these tables contain users profile…after finished profile creation click the view profile option…but its not show the particular user information…its shows all the user details…

This is my pbm…how can i get information for each user from multible tables…

Pls help me guys…


user tblregistration tble:

Reg_Id	         bigint	255	
Reg_CreatedFor	 text	        0	
Reg_UserName	 varchar	15	
Reg_Password	 varchar	12	
Reg_ConfirmPwd	 varchar	12	
Reg_Name	           text	0	
Reg_Email	          varchar	30	
Reg_Gender	           text	 0			
Reg_DOB	         date	        0						
Reg_Religion	 varchar	20		
Reg_MotherTongue varchar	75			
Reg_Country	 varchar	20	


user tblprofile table:
Reg_Id			  bigint	255
Prof_FirstName	          varchar	30							
Prof_LastName	          varchar	30							
Prof_Age	                    int	        3						
Prof_Martial_Status	  varchar	25					
Prof_Edu	                  varchar	40					
Prof_Edu_Detail	          varchar	200					
Prof_Occupation	          varchar	25				
Prof_Annual_Income	  varchar	25				
Prof_Caste	                  varchar	30		
Prof_Sub_Caste	          varchar	30					
Prof_Gothram	          varchar	30				
Prof_Star	                  varchar	20	
Prof_Raasi	                   varchar	20	
Prof_Dhosam	          varchar	25	
Prof_About_Yourself	  varchar	175	
Prof_Expectation	          varchar	200	

user tblfamily table:

Reg_Id	                bigint	255	
Prof_Father_Name	varchar	30	
Prof_Mother_Name	varchar	30	
Prof_Father_Occupation	varchar	50	
Prof_Mother_Occupation	varchar	50	
Prof_Family_Value	varchar	25	
Prof_Family_Type	varchar	25	
Prof_Family_Status	varchar	25	
Prof_About_Family	varchar	255	
Prof_Howdoyouknow	varchar	25	

my view pgm coding:

<?php

session_start();
  $_SESSION['uname'];
  ob_start();

?>



<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
table
{
color:#000000;
text-align:left;
width:700px;
border:thin;
background-color:#47942E;
}
</style>

</head>

<body>
<form>
 <td align="right"><div id="search"><p >Welcome {<?php echo ucwords($_SESSION['uname']);?>} </p>
	    <p></p>	
	    <a href="logout.php">Logout</a></div>
        </div> </td>

</form>
<p>
  <?php
  

$con=mysql_connect("localhost","root","");
mysql_select_db("matrimony",$con);

$result = mysql_query("SELECT * FROM tblprofile WHERE `uname` NOT LIKE '$_SESSION[uname]'") or die(mysql_error());
echo "<table border='1' align='left' >";
echo "<b>Personal Information</b>";
 echo "<br>"; 
  echo "<br>";
while($row = mysql_fetch_array($result))
  {
    echo "<tr>";
  echo  "<th width='300px'> UserName </th>";
  echo "<td width='400px'>" . $row['Reg_UserName'] . "</td>"; 
  echo "</tr>"; 
  
  echo "<tr>";
  echo  "<th width='300px'> First Name </th>";
  echo "<td width='400px'>" . $row['Prof_FirstName'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Last Name </th>";
  echo "<td>" . $row['Prof_LastName'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Age </th>";
  echo "<td>" . $row['Prof_Age'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Martial Status </th>";
  echo "<td>" . $row['Prof_Martial_Status'] . "</td>"; 
  echo "</tr>";  
 
  echo "<tr>";
  echo  "<th> Education </th>";
  echo "<td>" . $row['Prof_Edu'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Education in Detail </th>";
  echo "<td>" . $row['Prof_Edu_Detail'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Occupation </th>";
  echo "<td>" . $row['Prof_Occupation'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> His / Her Annual Income </th>";
  echo "<td>" . $row['Prof_Annual_Income'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Caste </th>";
  echo "<td>" . $row['Prof_Caste'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Sub Caste </th>";
  echo "<td>" . $row['Prof_Sub_Caste'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Gothra(m) </th>";
  echo "<td>" . $row['Prof_Gothram'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Star </th>";
  echo "<td>" . $row['Prof_Star'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Raasi / Moon Sign </th>";
  echo "<td>" . $row['Prof_Raasi'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Dhosham / Mangalik </th>";
  echo "<td>" . $row['Prof_Dhosam'] . "</td>"; 
  echo "</tr>"; 
  
  echo "<tr>";
  echo  "<th> More About Self </th>";
  echo "<td>" . $row['Prof_About_Yourself'] . "</td>"; 
  echo "</tr>"; 
  
  echo "<tr>";
  echo  "<th> Your Expectation </th>";
  echo "<td>" . $row['Prof_Expectation'] . "</td>"; 
  echo "</tr>"; 
  
  
  }
 
  
echo "</table>";
mysql_close($con);

  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
 
 
 ?>
</p>

<p>
  <?php
$con=mysql_connect("localhost","root","");
mysql_select_db("matrimony",$con);
$result=mysql_query("SELECT * FROM tblcontacts  where uname ='".$_SESSION['uname']."' ");
echo "<table border='1' align='left' height='300px' >";
echo "<b>Contact Information</b>";
  echo "<br>"; 
  echo "<br>";
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";  
  echo  "<th width='300px'> Citizenship </th>";
  echo "<td width='400px'>" . $row['Cont_Citizenship'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Address </th>";
  echo "<td>" . $row['Cont_Address'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> City </th>";
  echo "<td>" . $row['Cont_City'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> State </th>";
  echo "<td>" . $row['Cont_State'] . "</td>"; 
  echo "</tr>";  
 
  echo "<tr>";
  echo  "<th> Country </th>";
  echo "<td>" . $row['Cont_Country'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Pincode </th>";
  echo "<td>" . $row['Cont_Pincode'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Phone </th>";
  echo "<td>" . $row['Cont_Phone'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Mobile </th>";
  echo "<td>" . $row['Cont_Mobile'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Email </th>";
  echo "<td>" . $row['Cont_Email'] . "</td>"; 
  echo "</tr>";  
  
  }
echo "</table>";
mysql_close($con);
 
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>";
 
 ?>
</p>

<p>
 <?php
$con=mysql_connect("localhost","root","");
mysql_select_db("matrimony",$con);
$result=mysql_query("SELECT * FROM tblpersonaldetails  where uname ='".$_SESSION['uname']."' ");
echo "<table border='1' align='left'>";
echo "<b>Primary Information</b>";
 echo "<br>"; 
  echo "<br>";
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo  "<th width='300px'> Physical Status </th>";
  echo "<td width='400px'>" . $row['Prof_Physical_Status'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Body Type </th>";
  echo "<td>" . $row['Prof_Body_Type'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Complexion </th>";
  echo "<td>" . $row['Prof_Complexian'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Height </th>";
  echo "<td>" . $row['Prof_Height'] . "</td>"; 
  echo "</tr>";  
 
  echo "<tr>";
  echo  "<th> Weight </th>";
  echo "<td>" . $row['Prof_Weight'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Eating Habit </th>";
  echo "<td>" . $row['Prof_Eating_Habit'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Drinking Habit </th>";
  echo "<td>" . $row['Prof_Drinking_Habit'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Smoking Habit </th>";
  echo "<td>" . $row['Prof_Smoking_Habit'] . "</td>"; 
  echo "</tr>";  
    
  }
echo "</table>";
mysql_close($con);

  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  echo "<br>"; 
  echo "<br>";
  echo "<br>";
  
?>
</p>

<p>
 <?php
$con=mysql_connect("localhost","root","");
mysql_select_db("matrimony",$con);
$result=mysql_query("SELECT * FROM tblfamilydetails  whereuname ='".$_SESSION['uname']."' ");
echo "<table border='1' align='left'>";
echo "<b>Family Information</b>";
 echo "<br>"; 
  echo "<br>";
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo  "<th width='300px'> Father Name </th>";
  echo "<td width='400px'>" . $row['Prof_Father_Name'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Mother Name  </th>";
  echo "<td>" . $row['Prof_Mother_Name'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Father Occupation </th>";
  echo "<td>" . $row['Prof_Father_Occupation'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Mother Occupation </th>";
  echo "<td>" . $row['Prof_Mother_Occupation'] . "</td>"; 
  echo "</tr>";  
 
  echo "<tr>";
  echo  "<th> Your Family Value </th>";
  echo "<td>" . $row['Prof_Family_Value'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Family Type </th>";
  echo "<td>" . $row['Prof_Family_Type'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> Your Family Status </th>";
  echo "<td>" . $row['Prof_Family_Status'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> About Parents & Siblings </th>";
  echo "<td>" . $row['Prof_About_Family'] . "</td>"; 
  echo "</tr>";  
  
  echo "<tr>";
  echo  "<th> How do you know about us? </th>";
  echo "<td>" . $row['Prof_Howdoyouknow'] . "</td>"; 
  echo "</tr>";  
  
  }
echo "</table>";
mysql_close($con);

 ?>
</p>

</body>
</html>

personal information design:

<?php
session_start();
  $_SESSION['uname'];
  ob_start();
  error_reporting(E_PARSE);
?>

<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>

<title>Matrimony Website</title>

</head>

<body>
<form name="f1" method="post" action="per.php" onSubmit="">
  <div align="center">
   <table border="0" cellpadding="2" cellspacing="6" style="border-collapse: collapse" 
	bordercolor="#F4F4F4" width="95%" id="AutoNumber12" height="226">
      
      <tr>
        <td height="30"  colspan="3" bgcolor="#F7F7F7">
          <p style="margin-left: 16"><strong>Personal Information </strong> </p></td>
		        <td><p >Welcome {<?php echo ucwords($_SESSION['uname']);?>} </p></td>
      </tr>
      
      <tr>
        <td height="30" align="right" colspan="2" bgcolor="#F7F7F7">
          <p style="margin-left: 16"><font class="bluehead">First Name </font><font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></p>
	     </td>
        <td width="40%" height="30" bgcolor="#F7F7F7">                          
          <p style="margin-left: 3"><input name="prof_firstname" type="text" class="sl_inputbox" 
		  id="prof_firstname" tabindex="8" size="36" maxlength="49"></p>
		</td>
        <td width="34%" height="30" bgcolor="#F7F7F7"> </td>
      </tr>
      
      <tr>
       <td height="30" align="right" colspan="2" bgcolor="#F7F7F7">
        <p style="margin-left: 16">Last Name <font face="Arial"><b><font color="#FF0000" size="3">*
		</font></b></font></p>                    
	   </td>
       <td width="40%" height="30" bgcolor="#F7F7F7">             
        <p style="margin-left: 3">
        <input name="prof_lastname" type="text" class="sl_inputbox" id="prof_lastname" 
		tabindex="8" size="36" maxlength="49"/></p>
	  </td>
        <td width="34%" height="30" bgcolor="#F7F7F7"> </td>
     </tr>
      
     <tr>
       <td height="30" bgcolor="#F7F7F7" align="right" colspan="2">
       <p style="margin-left: 16"><font class="bluehead">Age</font><font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></p> 
	  </td>
      <td width="40%" height="30" bgcolor="#F7F7F7">
	   <p style="margin-left: 3">
        <!--webbot bot="Validation" s-data-type="Integer" s-number-separators=",
		" i-maximum-length="2" --><input name="prof_age" type="text" 
		class="sl_inputbox" id="prof_age" tabindex="4" size="2" maxlength="2"></p>      </td>
      <td width="34%" height="30" bgcolor="#F7F7F7">
        <p style="margin-left: 4"> </p>
	  </td>
    </tr>
      <tr>
        <td height="30" align="right" colspan="2">
        <p style="margin-left: 16"><font class="bluehead">Marital 
        Status</font><font face="Arial"><b><font color="#FF0000" size="3">*
        </font></b></font></p>                      
		</td>
        <td width="40%" height="30">
         <p style="margin-left: 3">
       <select name="prof_martial_status" size="1" class="selectbox" 
	   id="prof_martial_status" tabindex="5">
           <option value="0" selected>-Select Marital Status-</option>
           <option value="UnMarried">UnMarried</option>
           <option value="Widowed">Widowed</option>                       
           <option value="Divorced">Divorced</option>
           <option value="Separated">Separated</option>
        </select></p>
	    </td>
         <td width="34%" height="30"> </td>
       </tr>
      <tr>
        <td height="30" bgcolor="#F7F7F7" align="right" colspan="2">        
        <p style="margin-left: 16"><font class="bluehead">Education</font>
		<font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></p>       </td>
        <td width="40%" height="30" bgcolor="#F7F7F7">
          <p style="margin-left: 3">
         <select name="prof_edu" size="1" class="selectbox" id="prof_edu" tabindex="6">
            <option SELECTED value="0">--Select Education--</option>
            <option value="Bachelor in Computer Science">Bachelor in Computer Science</option>
            <option value="Masters in Computer Science">Masters in Computer Science</option>
            <option value="Bachelor in Engineering">Bachelor in Engineering</option>
            <option value="Masters in Engineering">Masters in Engineering</option>
            <option value="Bachelor in Science">Bachelor in Science</option>
            <option value="Masters in Science">Masters in Science</option>
            <option value="Bachelor in Arts/Commerce">Bachelor in Arts/Commerce</option>
            <option value="Masters in Arts/Commerce">Masters in Arts/Commerce</option>
            <option value="Medicine">Medicine</option>
            <option value="Management">Management</option>
            <option value="Phd">Phd</option>
            <option value="Law">Law</option>
            <option value="Student">Student</option>      
            <option value="Diploma">Diploma</option>
            <option value="High School">High School</option>
        <!--- <option value="-">Other</option> --></select></p>
		</td>
        <td width="34%" height="30" bgcolor="#F7F7F7"> </td>
      </tr>
      <tr>
        <td height="30" align="right" colspan="2">       
        <font class="bluehead">Educa<span lang="en-us">tion in Detail</span></font>
		<font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></td>
       <td width="40%" height="30">
         <p style="margin-left: 3">
        <input name="prof_edu_detail" type="text" class="sl_inputbox" 
		id="prof_edu_detail" tabindex="7" size="36" maxlength="49"></p>                      
	  </td>
      <td width="34%" height="30"><b>
        <font face="Arial" size="2">• </font><span lang="en-us">                           
        <font face="Arial" size="1">Detail Degree/Diploma ex. B.E(Comp.Sc),M.S / B.Com., M.B.A etc
		</font></span></b>
	  </td>
     </tr>
      <tr>
       <td height="30" align="right" colspan="2" bgcolor="#F7F7F7">
        <p style="margin-left: 16"><font class="bluehead">Occupation</font>
		<font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></p>       </td>
        <td width="40%" height="30" bgcolor="#F7F7F7">                        
         <p style="margin-left: 3">
        <input name="prof_occupation" type="text" class="sl_inputbox" 
		id="prof_occupation" tabindex="8" size="36" maxlength="49"></p>
	  </td>
        <td width="34%" height="30" bgcolor="#F7F7F7"> </td>
      </tr>
      <tr>
       <td height="31" align="right" colspan="2" bgcolor="#F7F7F7">
         <font class="bluehead"><span lang="en-us">His / Her Annual 
        Income</span></font><font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font>
	   </td>
        <td width="40%" height="31" bgcolor="#F7F7F7">
         <p style="margin-left: 3">
          <select NAME="prof_annual_income" SIZE="1" class="selectbox" 
		  id="prof_annual_income" tabindex="39">
              <option selected value="0">--Select Annual Income--</option>                            
              <option value="No Income at the moment">No Income at the moment</option>
              <option value="Do not wish to specify">Do not wish to specify </option>
              <option value="Less than Rs. 1 Lakh">Less than Rs. 1 Lakh</option>
              <option value="Above Rs.1 Lakh to Rs.1.5 Lakh">Above Rs. 1 Lakh to Rs. 1.5 Lakh</option>
              <option value="Above Rs.1.5 Lakh to Rs.2 Lakh">Above Rs. 1.5 Lakh to Rs. 2 Lakh</option>
              <option value="Above Rs.2 Lakh to Rs.2.5 Lakh">Above Rs. 2 Lakh to Rs. 2.5 Lakh</option>
              <option value="Above Rs.2.5 Lakh to Rs.3 Lakh">Above Rs. 2.5 Lakh to Rs. 3 Lakh</option>
              <option value="Above Rs.3 Lakh to Rs.4 Lakh">Above Rs. 3 Lakh to Rs. 4 Lakh</option>
              <option value="Above Rs.4 Lakh to Rs.5 Lakh">Above Rs. 4 Lakh to Rs. 5 Lakh</option>
              <option value="Above Rs.5 Lakh to Rs.6 Lakh">Above Rs. 5 Lakh to Rs. 6 Lakh</option>
              <option value="Above Rs.6 Lakh to Rs.7 Lakh">Above Rs. 6 Lakh to Rs. 7 Lakh</option>
              <option value="Above Rs.7 Lakh to Rs.8 Lakh">Above Rs. 7 Lakh to Rs. 8 Lakh</option>
              <option value="Above Rs.8 Lakh to Rs.9 Lakh">Above Rs. 8 Lakh to Rs. 9 Lakh</option>
              <option value="Above Rs.9 Lakh to Rs.10 Lakh">Above Rs. 9 Lakh to Rs. 10 Lakh</option>
              <option value="Above Rs.10 Lakh to Rs.12 Lakh">Above Rs. 10 Lakh to Rs. 12 Lakh</option>
              <option value="Above Rs.12 Lakh to Rs.14 Lakh">Above Rs. 12 Lakh to Rs. 14 Lakh</option>
              <option value="Above Rs.14 Lakh to Rs.16 Lakh">Above Rs. 14 Lakh to Rs. 16 Lakh</option>
              <option value="Above Rs.16 Lakh to Rs.18 Lakh">Above Rs. 16 Lakh to Rs. 18 Lakh</option>
              <option value="Above Rs.18 Lakh to Rs.20 Lakh">Above Rs. 18 Lakh to Rs. 20 Lakh</option>
              <option value="Above Rs.20 Lakh to Rs.22 Lakh">Above Rs. 20 Lakh to Rs. 22 Lakh</option>
              <option value="Above Rs.22 Lakh to Rs.25 Lakh">Above Rs. 22 Lakh to Rs. 25 Lakh</option>
              <option value="Above Rs.25 Lakh to Rs.30 Lakh">Above Rs. 25 Lakh to Rs. 30 Lakh</option>
              <option value="Above Rs.30 Lakh to Rs.35 Lakh">Above Rs. 30 Lakh to Rs. 35 Lakh</option>
              <option value="Above Rs.35 Lakh to Rs.40 Lakh">Above Rs. 35 Lakh to Rs. 40 Lakh</option>
              <option value="Above Rs.40 Lakh to Rs.45 Lakh">Above Rs. 40 Lakh to Rs. 45 Lakh</option>
              <option value="Above Rs.45 Lakh to Rs.50 Lakh">Above Rs. 45 Lakh to Rs. 50 Lakh</option>
              <option value="Above Rs.50 Lakh to Rs.60 Lakh">Above Rs. 50 Lakh to Rs. 60 Lakh</option>
              <option value="Above Rs.60 Lakh to Rs.70 Lakh">Above Rs. 60 Lakh to Rs. 70 Lakh</option>
              <option value="Above Rs.70 Lakh to Rs.80 Lakh">Above Rs. 70 Lakh to Rs. 80 Lakh</option>
              <option value="Above Rs.80 Lakh to Rs.90 Lakh">Above Rs. 80 Lakh to Rs. 90 Lakh</option>
              <option value="Above Rs.90 Lakh to Rs.1 Crore">Above Rs. 90 Lakh to Rs. 1 Crore</option>
              <option value="Above Rs.1 Crore to Rs.1.2 Crore">Above Rs. 1 Crore to Rs. 1.2 Crore
			  </option>
              <option value="Above Rs.1.2 Crore to Rs.1.4 Crore">Above Rs. 1.2 Crore to Rs. 1.4 Crore		              </option>
              <option value="Above Rs.1.4 Crore to Rs.1.6 Crore">Above Rs. 1.4 Crore to Rs. 1.6 Crore              </option>
              <option value="Above Rs.1.6 Crore to Rs.1.8 Crore">Above Rs. 1.6 Crore to Rs. 1.8 Crore              </option>
              <option value="Above Rs.1.8 Crore to Rs.2 Crore">Above Rs. 1.8 Crore to Rs. 2 Crore
			  </option>
              <option value="Above Rs.2 Crore to Rs.2.5 Crore">Above Rs. 2 Crore to Rs. 2.5 Crore
			  </option>
              <option value="Above Rs.2.5 Crore to Rs.3 Crore">Above Rs. 2.5 Crore to Rs. 3 Crore
			  </option>
              <option value="Above Rs.3 Crore">Above Rs.3 Crore</option>
        </select></p>                      </td>
           <td width="34%" height="31" bgcolor="#F7F7F7"> </td>
         </tr>
      <tr>
        <td height="30" align="right" colspan="2">
         <p style="margin-left: 16"><font class="bluehead">Caste</font>
		 <font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></p>        
		</td>
        <td width="40%" height="30">
         <p style="margin-left: 3">
          <select name="prof_caste" size="1" class="selectbox" id="prof_caste" tabindex="10">
            <option value="0">------- Select Caste --------</option>
            <option value="Caste doesnot matter">Caste doesnot matter </option>
            <option value="Unspecified / Others">Unspecified / Others </option>
            <option value="6000 Niyogi">6000 Niyogi</option>
            <option value="96K Kokanastha">96K Kokanastha</option>
            <option value="Ad Dharmi">Ad Dharmi</option>
            <option value="Adi Dravida">Adi Dravida</option>
            <option value="Agarwal">Agarwal</option>
            <option value="Agnikula Kshatriya">Agnikula Kshatriya </option>
            <option value="Agri">Agri</option>
            <option value="Ahom">Ahom</option>
            <option value="Ambalavasi">Ambalavasi</option>
            <option value="Anavil Brahmin">Anavil Brahmin</option>
            <option value="Ansari">Ansari</option>
            <option value="Arain">Arain</option>
            <option value="Arora">Arora</option>
            <option value="Arunthathiyar">Arunthathiyar</option>
            <option value="Arya Vysya">Arya Vysya</option>
            <option value="Aryasamaj">Aryasamaj</option>
            <option value="Awan">Awan</option>
            <option value="Bahi">Bahi</option>
            <option value="Baidya">Baidya</option>
            <option value="Baishnab">Baishnab</option>
            <option value="Baishya">Baishya</option>
            <option value="Balija">Balija</option>
            <option value="Banik">Banik</option>
            <option value="Baniya">Baniya</option>
            <option value="Barujibi">Barujibi</option>
            <option value="Bengali">Bengali</option>
            <option value="Besta">Besta</option>
            <option value="Bhandari">Bhandari</option>
            <option value="Bhatia">Bhatia</option>
            <option value="Bhavasar Kshatriya">Bhavasar Kshatriya </option>
            <option value="Bhovi">Bhovi</option>
            <option value="Billava">Billava</option>
            <option value="Bohra">Bohra</option>
            <option value="Born Again">Born Again</option>
            <option value="Boyer">Boyer</option>
            <option value="Brahmbatt">Brahmbatt</option>
            <option value="Brahmin">Brahmin</option>
            <option value="Brahmin - Anavil">Brahmin - Anavil</option>
            <option value="Brahmin - Audichya">Brahmin - Audichya </option>
            <option value="Brahmin - Barendra">Brahmin - Barendra </option>
            <option value="Brahmin - Bengali">Brahmin - Bengali </option>
            <option value="Brahmin - Bhatt">Brahmin - Bhatt</option>
            <option value="Brahmin - Bhumihar">Brahmin - Bhumihar </option>
            <option value="Brahmin - Daivadnya">Brahmin - Daivadnya </option>
            <option value="Brahmin - Danua">Brahmin - Danua</option>
            <option value="Brahmin - Deshastha">Brahmin - Deshastha </option>
            <option value="Brahmin - Dhiman">Brahmin - Dhiman</option>
            <option value="Brahmin - Dravida">Brahmin - Dravida </option>
            <option value="Brahmin - Garhwali">Brahmin - Garhwali </option>
            <option value="Brahmin - Gaur">Brahmin - Gaur</option>
            <option value="Brahmin - Goswami">Brahmin - Goswami </option>
            <option value="Brahmin - Gurukkal">Brahmin - Gurukkal </option>
            <option value="Brahmin - Halua">Brahmin - Halua</option>
            <option value="Brahmin - Havyaka">Brahmin - Havyaka </option>
            <option value="Brahmin - Hoysala">Brahmin - Hoysala </option>
            <option value="Brahmin - Iyengar">Brahmin - Iyengar </option>
            <option value="Brahmin - Iyer">Brahmin - Iyer</option>
            <option value="Brahmin - Jhadua">Brahmin - Jhadua</option>
            <option value="Brahmin - Kanyakubj">Brahmin - Kanyakubj </option>
            <option value="Brahmin - Karhade">Brahmin - Karhade </option>
            <option value="Brahmin - Kokanastha">Brahmin - Kokanastha </option>
            <option value="Brahmin - Kota">Brahmin - Kota</option>
            <option value="Brahmin - Kulin">Brahmin - Kulin</option>
            <option value="Brahmin - Kumoani">Brahmin - Kumoani </option>
            <option value="Brahmin - Madhwa">Brahmin - Madhwa</option>
            <option value="Brahmin - Maithil">Brahmin - Maithil </option>
            <option value="Brahmin - Modh">Brahmin - Modh</option>
            <option value="Brahmin - Mohyal">Brahmin - Mohyal</option>
            <option value="Brahmin - Nagar">Brahmin - Nagar</option>
            <option value="Brahmin - Namboodiri">Brahmin - Namboodiri </option>
            <option value="Brahmin - Niyogi">Brahmin - Niyogi</option>
            <option value="Brahmin - Panda">Brahmin - Panda</option>
            <option value="Brahmin - Pandit">Brahmin - Pandit</option>
            <option value="Brahmin - Punjabi">Brahmin - Punjabi </option>
            <option value="Brahmin - Rarhi">Brahmin - Rarhi</option>
            <option value="Brahmin - Rigvedi">Brahmin - Rigvedi </option>
            <option value="Brahmin - Rudraj">Brahmin - Rudraj</option>
            <option value="Brahmin - Sakaldwipi">Brahmin - Sakaldwipi </option>
            <option value="Brahmin - Sanadya">Brahmin - Sanadya </option>
            <option value="Brahmin - Sanketi">Brahmin - Sanketi </option>
            <option value="Brahmin - Saraswat">Brahmin - Saraswat </option>
            <option value="Brahmin - Saryuparin">Brahmin - Saryuparin </option>
            <option value="Brahmin - Shivhalli">Brahmin - Shivhalli </option>
            <option value="Brahmin - Shrimali">Brahmin - Shrimali </option>
            <option value="Brahmin - Smartha">Brahmin - Smartha </option>
            <option value="Brahmin - Sri Vishnava">Brahmin - Sri Vishnava </option>
            <option value="Brahmin - Stanika">Brahmin - Stanika </option>
            <option value="Brahmin - Tamil">Brahmin - Tamil</option>
            <option value="Brahmin - Telugu">Brahmin - Telugu</option>
            <option value="Brahmin - Tyagi">Brahmin - Tyagi</option>
            <option value="Brahmin - Vaidiki">Brahmin - Vaidiki </option>
            <option value="Brahmin - Vyas">Brahmin - Vyas</option>
            <option value="Bretheren">Bretheren</option>
            <option value="Bunt">Bunt</option>
            <option value="Chamar">Chamar</option>
            <option value="Chambhar">Chambhar</option>
            <option value="Chandravanshi Kahar">Chandravanshi Kahar </option>
            <option value="Chasa">Chasa</option>
            <option value="Chaudary">Chaudary</option>
            <option value="Chaurasia">Chaurasia</option>
            <option value="Chettiar">Chettiar</option>
            <option value="Chhetri">Chhetri</option>
            <option value="Church of South India">Church of South India </option>
            <option value="CKP">CKP</option>
            <option value="Coorgi">Coorgi</option>
            <option value="Dawoodi Bhora">Dawoodi Bhora</option>
            <option value="Dekkani">Dekkani</option>
            <option value="Devadiga">Devadiga</option>
            <option value="Devendra Kula Vellalar">Devendra Kula Vellalar </option>
            <option value="Devang Koshthi">Devang Koshthi</option>
            <option value="Devanga - Kannada">Devanga - Kannada </option>
            <option value="Devanga - Telugu">Devanga - Telugu</option>
            <option value="Dhaneshawat Vaish">Dhaneshawat Vaish </option>
            <option value="Dhangar">Dhangar</option>
            <option value="Dheevara">Dheevara</option>
            <option value="Dhiman">Dhiman</option>
            <option value="Dhoba">Dhoba</option>
            <option value="Dhobi">Dhobi</option>
            <option value="Digambar">Digambar</option>
            <option value="Dudekula">Dudekula</option>
            <option value="Ediga">Ediga</option>
            <option value="Evangelist">Evangelist</option>
            <option value="Ezhava">Ezhava</option>
            <option value="Ezhuthachan">Ezhuthachan</option>
            <option value="Gabit">Gabit</option>
            <option value="Gandla">Gandla</option>
            <option value="Ganiga">Ganiga</option>
            <option value="Garhwali">Garhwali</option>
            <option value="Gavara">Gavara</option>
            <option value="Ghumar">Ghumar</option>
            <option value="Goala">Goala</option>
            <option value="Goan">Goan</option>
            <option value="Gomantak Maratha">Gomantak Maratha</option>
            <option value="Goswami">Goswami</option>
            <option value="Goud">Goud</option>
            <option value="Gounder">Gounder</option>
            <option value="Gowda">Gowda</option>
            <option value="Gudia">Gudia</option>
            <option value="Gujarati">Gujarati</option>
            <option value="Gupta">Gupta</option>
            <option value="Gurjar">Gurjar</option>
            <option value="Hanafi">Hanafi</option>
            <option value="Intercaste">Intercaste</option>
            <option value="Jacobite">Jacobite</option>
            <option value="Jaiswal">Jaiswal</option>
            <option value="Jangam">Jangam</option>
            <option value="Jat">Jat</option>
            <option value="Kaibarta">Kaibarta</option>
            <option value="Kallar">Kallar</option>
            <option value="Kalinga">Kalinga</option>
            <option value="Kalita">Kalita</option>
            <option value="Kalwar">Kalwar</option>
            <option value="Kamboj">Kamboj</option>
            <option value="Kamma">Kamma</option>
            <option value="Kansari">Kansari</option>
            <option value="Kapu">Kapu</option>
            <option value="Karana">Karana</option>
            <option value="Karmakar">Karmakar</option>
            <option value="Karuneegar">Karuneegar</option>
            <option value="Kasar">Kasar</option>
            <option value="Kashyap">Kashyap</option>
            <option value="Kayastha">Kayastha</option>
            <option value="Khandayat">Khandayat</option>
            <option value="Khandelwal">Khandelwal</option>
            <option value="Khatri">Khatri</option>
            <option value="Khoja">Khoja</option>
            <option value="Knanaya">Knanaya</option>
            <option value="Knanaya Catholic">Knanaya Catholic</option>
            <option value="Knanaya Jacobite">Knanaya Jacobite</option>
            <option value="Koli">Koli</option>
            <option value="Kongu Vellala Gounder">Kongu Vellala Gounder </option>
            <option value="Konkani">Konkani</option>
            <option value="Kori">Kori</option>
            <option value="Koshti">Koshti</option>
            <option value="Kshatriya">Kshatriya</option>
            <option value="Kudumbi">Kudumbi</option>
            <option value="Kulala / Kulalar / Kuyavar">Kulala / Kulalar / Kuyavar</option>
            <option value="Kulita">Kulita</option>
            <option value="Kumaoni Rajput">Kumaoni Rajput</option>
            <option value="Kumawat">Kumawat</option>
            <option value="Kumbara">Kumbara</option>
            <option value="Kumbhakar">Kumbhakar</option>
            <option value="Kumbhar">Kumbhar</option>
            <option value="Kumhar">Kumhar</option>
            <option value="Kummari">Kummari</option>
            <option value="Kunbi">Kunbi</option>
            <option value="Kurmi">Kurmi</option>
            <option value="Kurmi Kshatriya">Kurmi Kshatriya</option>
            <option value="Kuruba">Kuruba</option>
            <option value="Kuruhina Shetty">Kuruhina Shetty</option>
            <option value="Kurumbar">Kurumbar</option>
            <option value="Kutchi">Kutchi</option>
            <option value="Labbai">Labbai</option>
            <option value="Lambadi">Lambadi</option>
            <option value="Latin Catholic">Latin Catholic</option>
            <option value="Leva Patil">Leva Patil</option>
            <option value="Lingayat">Lingayat</option>
            <option value="Lohana">Lohana</option>
            <option value="Lubana">Lubana</option>
            <option value="Madiga">Madiga</option>
            <option value="Mahajan">Mahajan</option>
            <option value="Mahar">Mahar</option>
            <option value="Maharashtrian">Maharashtrian</option>
            <option value="Mahendra">Mahendra</option>
            <option value="Maheshwari">Maheshwari</option>
            <option value="Mahishya">Mahishya</option>
            <option value="Majabi">Majabi</option>
            <option value="Mala">Mala</option>
            <option value="Malankara">Malankara</option>
            <option value="Malayalee Namboodiri">Malayalee Namboodiri </option>
            <option value="Malayalee Variar">Malayalee Variar</option>
            <option value="Mali">Mali</option>
            <option value="Malik">Malik</option>
            <option value="Malla">Malla</option>
            <option value="Mangalorean">Mangalorean</option>
            <option value="Manipuri">Manipuri</option>
            <option value="Mapila">Mapila</option>
            <option value="Maraicar">Maraicar</option>
            <option value="Maratha">Maratha</option>
            <option value="Marthoma">Marthoma</option>
            <option value="Maruthuvar">Maruthuvar</option>
            <option value="Maravar">Maravar</option>
            <option value="Marwari">Marwari</option>
            <option value="Matang">Matang</option>
            <option value="Maurya">Maurya</option>
            <option value="Meena">Meena</option>
            <option value="Meenavar">Meenavar</option>
            <option value="Mehra">Mehra</option>
            <option value="Memon">Memon</option>
            <option value="Menon">Menon</option>
            <option value="Meru Darji">Meru Darji</option>
            <option value="Mochi">Mochi</option>
            <option value="Modak">Modak</option>
            <option value="Mogaveera">Mogaveera</option>
            <option value="Mudaliar">Mudaliar</option>
            <option value="Mudiraj">Mudiraj</option>
            <option value="Mughal">Mughal</option>
            <option value="Mukkulathor">Mukkulathor</option>
            <option value="Muthuraja">Muthuraja</option>
            <option value="Nadar">Nadar</option>
            <option value="Nai">Nai</option>
            <option value="Naicker">Naicker</option>
            <option value="Naidu">Naidu</option>
            <option value="Naik">Naik</option>
            <option value="Nair">Nair</option>
            <option value="Nambiar">Nambiar</option>
            <option value="Namosudra">Namosudra</option>
            <option value="Napit">Napit</option>
            <option value="Nayaka">Nayaka</option>
            <option value="Nepali">Nepali</option>
            <option value="Nhavi">Nhavi</option>
            <option value="OBC">OBC</option>
            <option value="Oswal">Oswal</option>
            <option value="Padmasali">Padmasali</option>
            <option value="Pal">Pal</option>
            <option value="Panchal">Panchal</option>
            <option value="Panicker">Panicker</option>
            <option value="Parkava Kulam">Parkava Kulam</option>
            <option value="Pasi">Pasi</option>
            <option value="Patel">Patel</option>
            <option value="Pathan">Pathan</option>
            <option value="Patnaick">Patnaick</option>
            <option value="Patra">Patra</option>
            <option value="Pentacost">Pentacost</option>
            <option value="Perika">Perika</option>
            <option value="Pillai">Pillai</option>
            <option value="Porwal">Porwal</option>
            <option value="Prajapati">Prajapati</option>
            <option value="Punjabi">Punjabi</option>
            <option value="Qureshi">Qureshi</option>
            <option value="Rajaka">Rajaka</option>
            <option value="Rajastani">Rajastani</option>
            <option value="Rajbonshi">Rajbonshi</option>
            <option value="Rajput">Rajput</option>
            <option value="Ramdasia">Ramdasia</option>
            <option value="Ramgariah">Ramgariah</option>
            <option value="Ravidasia">Ravidasia</option>
            <option value="Rawat">Rawat</option>
            <option value="Reddy">Reddy</option>
            <option value="Roman Catholic">Roman Catholic</option>
            <option value="Rowther">Rowther</option>
            <option value="Sadgope">Sadgope</option>
            <option value="Saha">Saha</option>
            <option value="Sahu">Sahu</option>
            <option value="Saini">Saini</option>
            <option value="Saliya">Saliya</option>
            <option value="Scheduled Caste">Scheduled Caste</option>
            <option value="Senai Thalaivar">Senai Thalaivar</option>
            <option value="Sepahia">Sepahia</option>
            <option value="Shafi">Shafi</option>
            <option value="Sheikh">Sheikh</option>
            <option value="Shetty">Shetty</option>
            <option value="Shimpi">Shimpi</option>
            <option value="Siddiqui">Siddiqui</option>
            <option value="Sindhi">Sindhi</option>
            <option value="Sindhi - Amil">Sindhi - Amil</option>
            <option value="Sindhi - Baibhand">Sindhi - Baibhand </option>
            <option value="Sindhi - Bhanusali">Sindhi - Bhanusali </option>
            <option value="Sindhi - Bhatia">Sindhi - Bhatia</option>
            <option value="Sindhi - Chhapru">Sindhi - Chhapru</option>
            <option value="Sindhi - Dadu">Sindhi - Dadu</option>
            <option value="Sindhi - Hyderabadi">Sindhi - Hyderabadi </option>
            <option value="Sindhi - Larai">Sindhi - Larai</option>
            <option value="Sindhi - Larkana">Sindhi - Larkana</option>
            <option value="Sindhi - Lohana">Sindhi - Lohana</option>
            <option value="Sindhi - Rohiri">Sindhi - Rohiri</option>
            <option value="Sindhi - Sahiti">Sindhi - Sahiti</option>
            <option value="Sindhi - Sakkhar">Sindhi - Sakkhar</option>
            <option value="Sindhi - Sehwani">Sindhi - Sehwani</option>
            <option value="Sindhi - Shikarpuri">Sindhi - Shikarpuri </option>
            <option value="Sindhi - Thatai">Sindhi - Thatai</option>
            <option value="SKP">SKP</option>
            <option value="Somvanshi">Somvanshi</option>
            <option value="Sonar">Sonar</option>
            <option value="Soni">Soni</option>
            <option value="Sourashtra">Sourashtra</option>
            <option value="Sozhiya Vellalar">Sozhiya Vellalar</option>
            <option value="Sundhi">Sundhi</option>
            <option value="Suthar">Suthar</option>
            <option value="Swakula Sali">Swakula Sali</option>
            <option value="Swarnakar">Swarnakar</option>
            <option value="Syed">Syed</option>
            <option value="Syrian Catholic">Syrian Catholic</option>
            <option value="Syrian Jacobite">Syrian Jacobite</option>
            <option value="Syrian Malabar">Syrian Malabar</option>
            <option value="Syrian Orthodox">Syrian Orthodox</option>
            <option value="Tamboli">Tamboli</option>
            <option value="Tanti">Tanti</option>
            <option value="Tantubai">Tantubai</option>
            <option value="Telaga">Telaga</option>
            <option value="Teli">Teli</option>
            <option value="Thakkar">Thakkar</option>
            <option value="Thakur">Thakur</option>
            <option value="Thevar">Thevar</option>
            <option value="Thigala">Thigala</option>
            <option value="Tili">Tili</option>
            <option value="Tribe">Tribe</option>
            <option value="Udayar">Udayar</option>
            <option value="Uppara">Uppara</option>
            <option value="Vaddera">Vaddera</option>
            <option value="Vaish">Vaish</option>
            <option value="Vaishnav">Vaishnav</option>
            <option value="Vaishya">Vaishya</option>
            <option value="Valmiki">Valmiki</option>
            <option value="Vania">Vania</option>
            <option value="Vaniya">Vaniya</option>
            <option value="Vanjara">Vanjara</option>
            <option value="Vanjari">Vanjari</option>
            <option value="Vankar">Vankar</option>
            <option value="Vannar">Vannar</option>
            <option value="Vannia Kula Kshatriyar">Vannia Kula Kshatriyar </option>
            <option value="Vanniyar">Vanniyar</option>
            <option value="Varshney">Varshney</option>
            <option value="Veera Saivam">Veera Saivam</option>
            <option value="Veerashaiva">Veerashaiva</option>
            <option value="Velama">Velama</option>
            <option value="Velethadathu Nair">Velethadathu Nair </option>
            <option value="Vellalar">Vellalar</option>
            <option value="Vellama">Vellama</option>
            <option value="Veluthedathu Nair">Veluthedathu Nair </option>
            <option value="Vilakkithala Nair">Vilakkithala Nair </option>
            <option value="Vishwakarma">Vishwakarma</option>
            <option value="Viswabrahmin">Viswabrahmin</option>
            <option value="Vokaliga">Vokaliga</option>
            <option value="Vysya">Vysya</option>
            <option value="Yadav">Yadav</option>
            <option value="Yadava - Tamil">Yadava - Tamil</option>
            <option value="Yadava - Telugu">Yadava - Telugu</option>
        </select></p>
	  </td>
        <td width="34%" height="30"> </td>
     </tr>
      
      <tr>
        <td height="30" align="right" colspan="2">
        <font class="bluehead">Sub Caste</font></td>
        <td width="40%" height="30">
          <p style="margin-left: 3">
         <input name="prof_sub_caste" type="text" class="sl_inputbox" 
		 id="prof_sub_caste" tabindex="11" size="36" maxlength="39"></p>
	   </td>
        <td width="34%" height="30"> </td>
      </tr>
      <tr>
        <td height="30" align="right" colspan="2" bgcolor="#F7F7F7">
         <font class="bluehead">Gothra(m)</font></td>
        <td width="40%" height="30" bgcolor="#F7F7F7">
          <p style="margin-left: 3">
         <input name="prof_gothram" type="text" class="sl_inputbox" 
		 id="prof_gothram" tabindex="12" size="36" maxlength="39"></p>                      
		</td>
           <td width="34%" height="30" bgcolor="#F7F7F7"> </td>
      </tr>
      <tr>
        <td height="30" align="right" colspan="2"><font class="bluehead">Star</font>
		 <font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></td>
        <td width="40%" height="30">
          <p style="margin-left: 3">
          <select name="prof_star" size="1" class="selectbox" id="prof_star" tabindex="15">
             <option value="0" selected="selected">--Hindus Must Select Star--</option>
             <option value="01 Anuradha / Anusham / Anizham">Anuradha / Anusham / Anizham</option>
             <option value="02 Ardra / Thiruvathira">Ardra / Thiruvathira </option>
             <option value="03 Ashlesha / Ayilyam">Ashlesha / Ayilyam </option>
             <option value="04 Ashwini / Ashwathi">Ashwini / Ashwathi </option>
             <option value="05 Bharani">Bharani</option>
             <option value="06 Chitra / Chitha">Chitra / Chitha </option>
             <option value="07 Dhanista / Avittam">Dhanista / Avittam </option>
             <option value="08 Hastha / Atham">Hastha / Atham</option>
             <option value="09 Jyesta / Kettai">Jyesta / Kettai </option>
             <option value="10 Krithika / Karthika">Krithika / Karthika </option>
             <option value="11 Makha / Magam">Makha / Magam</option>
             <option value="12 Moolam / Moola">Moolam / Moola</option>
             <option value="13 Mrigasira / Makayiram">Mrigasira / Makayiram </option>
             <option value="14 Poorvabadrapada / Puratathi">Poorvabadrapada / Puratathi</option>
             <option value="15 Poorvapalguni / Puram / Pubbhe">Poorvapalguni / Puram / Pubbhe</option>
             <option value="16 Poorvashada / Pooradam">Poorvashada / Pooradam </option>
             <option value="17 Punarvasu / Punarpusam">Punarvasu / Punarpusam</option>
             <option value="18 Pushya / Poosam / Pooyam">Pushya / Poosam / Pooyam</option>
             <option value="19 Revathi">Revathi</option>
             <option value="20 Rohini">Rohini</option>
             <option value="21 Shatataraka / Sadayam / Satabishek">Shatataraka / Sadayam / Satabishek
			 </option>
             <option value="22 Shravan / Thiruvonam">Shravan / Thiruvonam </option>
             <option value="23 Swati / Chothi">Swati / Chothi</option>
             <option value="24 Uttarabadrapada / Uthratadhi">Uttarabadrapada / Uthratadhi</option>
             <option value="25 Uttarapalguni / Uthram">Uttarapalguni / Uthram</option>
             <option value="26 Uttarashada / Uthradam">Uttarashada / Uthradam </option>
             <option value="27 Vishaka / Vishakam">Vishaka / Vishakam </option>
             <option value="28 Do not know">Do not know</option>
         </select>
        </td>
         <td width="34%" height="30"> </td>
       </tr>
            
      <tr>
        <td height="30" align="right" colspan="2" bordercolor="#F7F7F7" bgcolor="#F7F7F7">
          <font class="bluehead">Ra<span lang="en-us">a</span>si / Moon 
            Sign</font><font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font>
	    </td>
         <td width="40%" height="30" bordercolor="#F7F7F7" bgcolor="#F7F7F7">
          <p style="margin-left: 3">
           <select name="prof_raasi" size="1" class="selectbox" id="prof_raasi" tabindex="16">
             <option value="0" selected>--Hindus Must Select Raasi--</option>
             <option value="01 Aries ( Mesha(m) )">Aries ( Mesha(m) )</option>
             <option value="02 Taurus ( Rishabam / Vrishaba )">Taurus ( Rishabam / Vrishaba )             </option>
             <option value="03 Gemini ( Mithuna(m) )">Gemini ( Mithuna(m) )</option>
             <option value="04 Cancer ( Kataka(m) )">Cancer ( Kataka(m) )</option>
             <option value="05 Leo ( Simha(m) )">Leo ( Simha(m) )</option>
             <option value="06 Virgo ( Kanni / Kanya )">Virgo ( Kanni / Kanya )</option>
             <option value="07 Libra ( Thula )">Libra ( Thula )</option>
             <option value="08 Scorpio ( Vrichiga(m) / Vrishchika )">Scorpio ( Vrichiga(m) /        
			  Vrishchika )</option>
             <option value="09 Sagittarius ( Dhanus )">Sagittarius ( Dhanus )</option>
             <option value="10 Capricorn ( Makara(m) )">Capricorn ( Makara(m) )</option>
             <option value="11 Aquarius ( Kumba(m) )">Aquarius ( Kumba(m) )</option>
             <option value="12 Pisces ( Meena(m) )">Pisces ( Meena(m) )</option>
             <option value="13 Do not know">Do not know</option>
           </select></p>
		 </td>
          <td width="34%" height="30" bordercolor="#F7F7F7" bgcolor="#F7F7F7"> </td>
       </tr>
      
      <tr>
        <td height="30" align="right" colspan="2">
         <font class="bluehead"><span lang="en-us">Dhosham / Mangalik</span></font>
		 <font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font></td>
        <td width="40%" height="30">
          <p style="margin-left: 3">
          <select name="prof_dhosam" size="1" class="selectbox" id="prof_dhosam" tabindex="17">
            <option value="0" selected>--Select Dhosham / Mangalik--</option>
            <option value="No">No</option>
            <option value="Yes">Yes</option>
            <option value="Do not know">Do not know</option>
          </select></p>
		 </td>
        <td width="34%" height="30"> </td>
      </tr>
       <tr>
        <td height="85" align="right" colspan="2" bgcolor="#F7F7F7">
          <p style="margin-left: 16"><font class="bluehead">
          <span lang="en-us">More About Self</span></font><font face="Arial"><b>
		  <font color="#FF0000" size="3">*</font></b></font></p>
		</td>
          <td width="40%" height="85" bgcolor="#F7F7F7">
           <p style="margin-left: 3">
            <!--webbot bot="Validation" i-maximum-length="300" -->
			<textarea name="prof_about_yourself" cols="47" rows="4" class="ml_inputbox" 
			id="prof_about_yourself" tabindex="41"></textarea></p> 
		  </td>
           <td width="34%" height="85" bgcolor="#F7F7F7" valign="top">
             <p style="margin-left: 1; margin-right:1"><b>
             <font face="Arial" size="2">•</font><font face="Arial" size="1">
             <span lang="en-us">MUST </span>Provide <span lang="en-us">
               your qualities(ex. jovial, hardworking etc), other skills, 
               hobbies, ambitions etc. (atleast 2 lines).
              <font color="#800000">SHOULD NOT INCLUDE contact number or 
                email address etc</font></span></font></b></p>
		    </td>
          </tr>
        <tr>
          <td height="70" align="right" colspan="2">
           <font class="bluehead"><span lang="en-us"> Your Expectation</span></font>
		   <font face="Arial"><b><font color="#FF0000" size="3">*</font></b></font>
		  </td>
           <td width="40%" height="70">
            <p style="margin-left: 3">
              <!--webbot bot="Validation" i-maximum-length="300" -->
			  <textarea name="prof_expectation" cols="47" rows="4" class="ml_inputbox" 
			  id="prof_expectation" tabindex="42"></textarea></p>
			</td>
               <td width="34%" height="70" valign="top">
                 <p style="margin-left: 1; margin-right: 1"><b>
                 <font face="Arial" size="2">•</font><font face="Arial" size="1">
				 <span lang="en-us">MUST </span>Provide <span lang="en-us">
				   your expectations in your partner, atleast in 2 lines.
				  <font color="#800000">
				  SHOULD NOT INCLUDE contact number or email address  references to other 
                       websites etc</font></span></font></b></p>
			 </td>
           </tr>
    </table> 
	
  </div>
  
  <p> </p>
 <div align="center">
 
   <table width="305" border="0" cellpadding="2" cellspacing="2">
      <tr>
        <td width="113"><label>
          <input type="submit" name="Submit" value="Submit" />
        </label></td>
        <td width="178"><label> <a href="ind.php">Back To Home </a></label></td>
      </tr>
    </table>
	
 </div>
 <p> </p>
 
</form>

</body>
</html>

this one is insert personal information php file:

<title>Matrimony Website</title>
<?php

  ob_start();
   error_reporting(E_PARSE);
   session_start();
  $_SESSION['uname'];
  
//Database connection...
	include("dbcon.php");


//Table...
	$table="tblprofile";
	
	$Submit=$_POST['Submit'];
	if($Submit=="Submit")
 	{
	 	$reg_id =addslashes($_POST['reg_id']);
		
		$prof_firstname = addslashes($_POST['prof_firstname']);
		$prof_lastname = addslashes($_POST['prof_lastname']);
		$prof_age =addslashes($_POST['prof_age']);
		$prof_martial_status = addslashes($_POST['prof_martial_status']);
		$prof_edu=	addslashes($_POST['prof_edu']);
		$prof_edu_detail  =addslashes($_POST['prof_edu_detail']);
		$prof_occupation =addslashes($_POST['prof_occupation']);		
		$prof_annual_income = addslashes($_POST['prof_annual_income']);
		$prof_caste = addslashes($_POST['prof_caste']);
		$prof_sub_caste = addslashes($_POST['prof_sub_caste']);
		$prof_gothram = addslashes($_POST['prof_gothram']);
		$prof_star = addslashes($_POST['prof_star']);
		$prof_raasi = addslashes($_POST['prof_raasi']);
		$prof_dhosam = addslashes($_POST['prof_dhosam']);
		$prof_about_yourself = addslashes($_POST['prof_about_yourself']);
		$prof_expectation= addslashes($_POST['prof_expectation']);
		
					
		$insertQuery="INSERT INTO $table VALUES
		 		                ('$reg_id',
								'$prof_firstname',							  	        
								'$prof_lastname',
								'$prof_age',
								'$prof_martial_status',
								'$prof_edu',
								'$prof_edu_detail',
								'$prof_occupation',
								'$prof_annual_income',
								'$prof_caste',
								'$prof_sub_caste ',
								'$prof_gothram',
								'$prof_star',
								'$prof_raasi',
								'$prof_dhosam',
								'$prof_about_yourself', 
                                 '$prof_expectation' 
                              )";

		$resultSet=mysql_query($insertQuery) or die('Mysql Error: ' . mysql_error());
		header("location:per1.html");

 	}
?>

i want the solution for this pbm guys…user only view his/her details…i dont know…pls post ur answer…its very helpful to me…

Regards,
Nandhagopal.J

Use joins and if you wish to fetch optional data user left OUTER join in your SQL Query and then its all how you handle the data in UI/View

Thx for ur help

$result = mysql_query(("SELECT * FROM tblprofile WHERE`UserName` = '".$_SESSION['uname']."'"); 

i done tat but it shows parse error

Off Topic:

ze goggles!! zey do nossink!!

Off Topic:

My eyes!

in fact, you dont even want that, because your table doesnt have a uname field. you want WHERE UserName = ‘“.$_SESSION[‘uname’].”’");

$result = mysql_query(“SELECT * FROM tblprofile WHERE uname NOT LIKE ‘$_SESSION[uname]’”)

NOT LIKE will choose every row EXCEPT the ones that are the same as your username. you want WHERE uname = ‘“.$_SESSION[‘uname’].”’");

There is no UserName field in tblprofile. :wink:

$result = mysql_query("SELECT * FROM tblprofile tp INNER JOIN tblregistration tr ON tp.Reg_ID=tr.Reg_ID WHERE tr.UserName='".$_SESSION['uname']."'");

Or something like that. :slight_smile:

$result = mysql_query((“SELECT * FROM tblprofile WHEREUserName = '”.$_SESSION[‘uname’].“'”);

its all show parse error

wen i put this code
$result = mysql_query(“SELECT * FROM tblprofile WHERE uname NOT LIKE ‘$_SESSION[uname]’”)

its shows this error…

Undefined index: uname in D:\wamp\www\matrimony\vc2.php on line 43
Unknown column ‘uname’ in ‘where clause’