";
echo "| ";
echo "";
echo "";
print $hw;
echo "";
echo "";
echo " | ";
echo"";
echo"";
echo ":";
echo "";
echo " | ";
echo "";
echo "";
echo $sp;
echo "";
echo " | ";
echo "";
}
if($x=="F")
{
$hw = "Husband";
echo "";
echo "| ";
echo "";
echo "";
print $hw;
echo "";
echo "";
echo " | ";
echo"";
echo"";
echo ":";
echo "";
echo " | ";
echo "";
echo "";
echo $sp;
echo "";
echo " | ";
echo "
";
}
// if($x=="N")
// {
// $hw = " ";
}
function children($mcode)
{
$qc = "SELECT children from memlistkla12 where mcode= $mcode";
$qcu = mysql_query($qc);
while ( $row = mysql_fetch_array($qcu))
{
$ch = $row[0];
}
if($ch == "N")
{
return;
}
else
{
echo "";
echo "| ";
echo "";
echo "";
print"Children";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo ":";
echo "";
echo " | ";
echo "";
echo "";
echo $ch;
echo "";
echo " | ";
echo "
";
}
}
function ishuswife($mcode)
{
$query1 = "SELECT wife,sex from memlistkla12 where mcode= $mcode";
$qrs = mysql_query($query1);
while($row=mysql_fetch_array($qrs))
{
if ($row['sex'] == "M")
$he="Wife";
else
$he="Husband";
}
return $he;
}
function ischildren($mcode)
{
$query1 = "SELECT * from memlistkla12 where mcode= $mcode";
$qrs = mysql_query($query1);
while($row=mysql_fetch_array($qrs))
{
if ($row['children'] != "")
$he1=1;
else
$he1=0;
}
return $he1;
}
function portfolio($mcode)
{
$query1 = "SELECT * from memlistkla12 where mcode= $mcode";
$qrs = mysql_query($query1);
while($row=mysql_fetch_array($qrs))
{
$portf=$row['portfolio'];
}
$portfo=explode(",",$portf);
$rows = implode('
', $portfo).'
';
$portfolio=1;
return $rows;
}
//checking functions
function wife($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['wife']=="")
$hewife=1;
else
$hewife=0;
}
return $hewife;
}
function offphone($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['offaddress']=="")
$heoffaddr=1;
else
$heoffaddr=0;
}
return $heoffaddr;
}
function resphone($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['resiaddress']=="")
$heresiaddr=1;
else
$heresiaddr=0;
}
return $heresiaddr;
}
function permphone($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['permaddress']=="")
$permaddr=1;
else
$permaddr=0;
}
return $permaddr;
}
function son($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['fathname']=="" && $row['mothname']=="")
$son=1;
else
$son=0;
}
return $son;
}
function quali($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['qualification']=="")
$qua=1;
else
$qua=0;
}
return $qua;
}
function dob($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['dateofbirth']=="")
$dob=1;
else
$dob=0;
}
return $dob;
}
function prof($mcode)
{
$query="SELECT * from memlistkla12 where mcode=$mcode";
$qrs=mysql_query($query);
while($row=mysql_fetch_array($qrs))
{
if ($row['profession']=="")
$prof=1;
else
$prof=0;
}
return $prof;
}
?>