''){
$qry=mysql_query("select MSecName from tbl_mainsection where MSecID='".$MSecID."'") or die("Invalid MSecID ".mysql_error());
if($qry){
$rows=mysql_num_rows($qry);
if($rows>0){
$data=mysql_fetch_row($qry);
$Head .=$data[0];
$mn=$data[0];
}
}
mysql_free_result($qry);
}else{
$qry=mysql_query("select * from tbl_mainsection order by rank") or die("Invalid MSecID ".mysql_error());
If(mysql_num_Rows($qry)>0){
$rs=mysql_fetch_array($qry);
$MSecID=$rs["MSecID"];
$Head .="".$rs["MSecName"]." » ";
}
mysql_free_result($qry);
}
$sqlp.= "MSecID='".$MSecID."'";
if($SecID<>''){
$qry=mysql_query("select SecName,SecImg from tbl_section where MSecID='".$MSecID."' and SecID='".$SecID."' order by rank") or die("Invalid MSecID ".mysql_error());
if($qry){
$rows=mysql_num_rows($qry);
if($rows>0){
$data=mysql_fetch_row($qry);
$sn=$data[0];
$Head ="".$mn." » ".$data[0];
}
}
mysql_free_result($qry);
}else{
$qry=mysql_query("select * from tbl_section where MSecID='".$MSecID."' order by rank") or die(mysql_error());
if(mysql_num_rows($qry)>0){
$rs=mysql_fetch_array($qry);
$SecID=$rs["SecID"];
$Head .=$rs["SecName"];
}
mysql_free_result($qry);
}
$sqlp.= " and SecID='".$SecID."'";
if($MainID<>'' && $MainID<>0){
$qry=mysql_query("select MainName,MainImg,PrdType from tbl_main where MSecID='".$MSecID."' and SecID='".$SecID."' and MainID='".$MainID."' order by rank") or die("Invalid MSecID ".mysql_error());
if($qry){
$rows=mysql_num_rows($qry);
if($rows>0){
$data=mysql_fetch_row($qry);
//$Head .=$data[0]."sssss";
$Head = $mn." » ".$sn." » ".$data[0];
}
}
mysql_free_result($qry);
}else{
$qrychk=mysql_query("select * from tbl_main where MSecID='".$MSecID."' and SecID='".$SecID."' order by rank") or die(mysql_error());
if(mysql_num_rows($qrychk)>0){
$rs=mysql_fetch_array($qrychk);
$MainID=$rs["MainID"];
$Head .= $rs["MainName"];
}
mysql_free_result($qrychk);
}
$sqlp.= " and MainID='".$MainID."'";
if($SubID<>'' && $SubID<>0){
$qry=mysql_query("select SubName,PrdType from tbl_sub where MSecID='".$MSecID."' and SecID='".$SecID."' and MainID='".$MainID."' and SubID='".$SubID."'") or die("Invalid MSecID ".mysql_error());
if($qry){
$rows=mysql_num_rows($qry);
if($rows>0){
$data=mysql_fetch_row($qry);
$Head .=$data[0];
}
}
mysql_free_result($qry);
}else{
$qrychk=mysql_query("select * from tbl_sub where MSecID='".$MSecID."' and SecID='".$SecID."' and MainID='".$MainID."' order by rank") or die(mysql_error());
if(mysql_num_rows($qrychk)>0){
$rs=mysql_fetch_array($qrychk);
$SubID=$rs["SubID"];
$Head .=$rs["SubName"];
}
mysql_free_result($qrychk);
}
$sqlp.= " and SubID='".$SubID."' and sOption='y' order by rank";
//echo("".$sqlp."");
?>
