t INNER JOIN tblFeature ON tblProduct.fldProductid = tblFeature.fldProductid) WHERE (tblProduct.fldProductid = "'.$_GET['m'].'")';
               $conn = connectdbAccess();
               $rs = $conn->Execute($sql);
               if (!$rs->EOF) {
                   echo '<h4>Module Description</h4>';
                   echo '<h4>'.$rs->Fields("fldProductName")->value.'</h4>';
                   echo '<div>'.$rs->Fields("fldfeatures")->value.'</div>';
//Display accreditation
echo '<br /><p>* Upon completion of each course, print your certificate from the Certification tab.<br />';

               } else {
                   echo '<h4>Module Description is not currently available</h4>';
               }
                   echo '<div style="text-align: center;"><span style="float: right;"><a href="programs.php" class="greybutton" id="moduleList">Return to Module List <img src="images/ButtongoldArows.png" style="margin-bottom: 3px;" /></a></span></div>';
                $conn->Close(); 
           } else {
           // NO MODULE ID THEN SHOW PROGRAM (2014-2015 = MGF0 for fldproductid)
           // 5 in a GROUP - ORDERED IN SEQUENCE BY PRODUCT CODE
$conn = connectdbAccess();
//$sql='where LEFT(fldCourseID,4)="MGF0" AND fldStudentID = '.$_SESSION['AGFSCID'].' ORDER BY fldProductid
for ($Phase = 15; $Phase >= 14; $Phase--) {
        if ($Phase === 15) {
        echo "<H1>Phase 15</H1>";
        $sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,5) = 'MGF25' AND  LEFT(fldPublisher,2) = 'TB' AND fldCategoryid = 12 ORDER BY fldProductid;";
        }
        
        if ($Phase === 14) {
        echo "<H1>Phase 14</H1>";
        $sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,5) = 'MGF24' AND  LEFT(fldPublisher,2) = 'TB' AND fldCategoryid = 12 ORDER BY fldProductid;";
    }
//    if ($Phase === 13) {
//        echo "<H1>Phase 13</H1>";
//        $sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,5) = 'MGF23' AND  LEFT(fldPublisher,2) = 'TB' AND fldCategoryid = 12 ORDER BY fldProductid;";
//    }
    
    
//            if ($Phase === 12) {
//	echo "<H1>Phase 12</H1>";
//	$sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,5) = 'MGF22' AND  LEFT(fldPublisher,2) = 'TB' AND fldCategoryid = 12 ORDER BY fldProductid;"; 			
//}; 
    
//            if ($Phase === 11) {
//	echo "<H1>Phase 11</H1>";
//	$sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,5) = 'MGF11' AND  LEFT(fldPublisher,2) = 'TA' AND fldCategoryid = 12 ORDER BY fldPublisher;"; 			
//};  
//
//        if ($Phase === 10) {
//	echo "<H1>Phase 10 (Registration Closed)</H1>";
//	$sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,4) = 'MGF1' AND  LEFT(fldPublisher,2) = 'T0' AND fldCategoryid = 12 ORDER BY fldProductid;"; 			
//};  

//    if ($Phase === 9) {
//	echo "<H1>Phase 9</H1>";
//	$sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,4) = 'MGF0' AND  LEFT(fldPublisher,2) = 'T9' AND fldCategoryid = 12 ORDER BY fldProductid;"; 			
//};  
//
//if ($Phase == 8) {
//	echo "<H1>Phase 8</H1>";
//	$sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,4) = 'MGF0' AND  LEFT(fldPublisher,2) = 'T8' AND fldCategoryid = 12 ORDER BY fldProductid;"; 			
//};  
//	if ($Phase == 7) {
//			echo "<H1>Phase 7</H1>";
//			$sql = "select fldProductName, fldProductid from tblProduct where LEFT(fldProductid,4) = 'MGF0' AND  LEFT(fldPublisher,2) = 'T7' AND fldCategoryid = 12 ORDER BY fldProductid;"; 			
//	};           
	$rs = $conn->Execute($sql);
        
	$i=1;
	$mark='';
        //echo $i;
	    while (!$rs->EOF) {
	        $linktext = 'Open Module';
	            
	    if (isset($_SESSION['AGFTRID'])&&$_SESSION['AGFTRID']>''){
	        $sqlMark = 'select fldCourseMark,fldDateCompleted from tblRegistrations where fldCourseID="'.$rs->Fields("fldProductid")->value.'" AND fldStudentID = '.$_SESSION['AGFTRID'].' ORDER BY fldCourseID';
	        $connMark = connectdbAccess('KWStudents.mdb');
	        $rsMark = $connMark->Execute($sqlMark);
	        if (!$rsMark->EOF) {
	        	$linktext = '<a href="courses.php?m=' . $rs->Fields("fldProductID")->value . '">Open Module</a>';
	        	if ($rsMark->Fields("fldDateCompleted")->value!=null)
	        		{$mark = $rsMark->Fields("fldCourseMark")->value . '% : ' . date("m/d/Y",strtotime($rsMark->Fields("fldDateCompleted")->value));
	        		$linktext='<a href="courses.php?m=' . $rs->Fields("fldProductID")->value . '">Review Module</a>';
	        		}else{
	        		$mark='';
	        		}
        	 	//if (is_file("presentation/" . $rs->fields("fldProductID")->value . "/index.html")) {
        	 	//	} else {
		        //	$linktext = "Coming Soon";        	 	
        	 	//	}

	        } else {
		        $linktext = '<a href="courses.php?m=' . $rs->Fields("fldProductID")->value . '">View Module</a>';
                        $mark='';
	        }
	        $connMark->Close();
	        
	    }
	        if ($_SESSION['AGFTRREG']==1){
//set the flow for phase 11, otherwise follow below
                    
if ($Phase>11){
    if ($i==1) {echo '<p id="cat1" class="programHeader">Module Series</p>';}
         echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';
}   elseif ($Phase===11) {
    //do phase 11 stuff
    //Group 1 (Individuals: 4 modules [MGF1101, MGF1110, MGF1111, MGF1112)
    if ($i==1) {echo '<p id="cat1" class="programHeader">Individuals</p>';}
    if ($i==5) {echo '<p id="cat1" class="programHeader">Real Estate</p>';}
    if ($i==8) {echo '<p id="cat1" class="programHeader">Small Business</p>';}
    if ($i==13) {echo '<p id="cat1" class="programHeader">Incapacity/Powers of Attorney</p>';}
    //if ($i==1) {echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //if ($i>9 and $i<13){echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //Group 2 (Real Estate: 3 modules [MGF1102,MGF1103,MGF1104]
    //if ($i==2) {echo '<p id="cat1" class="programHeader">Real Estate</p>';}
    //if ($i>1 and $i<5) {echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //Group 3 (Small Business: 5 modules [MGF1105,MGF1106,MGF1107,MGF1108,MGF1109]
    //if ($i==5) {echo '<p id="cat1" class="programHeader">Small Business</p>';}
    //if ($i>4 and $i<10) {echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //Group 4 (Incapacity/Powers of Attorney [MGF1113,MGF1114,MGF1115]
    //if ($i==13) {echo '<p id="cat1" class="programHeader">Incapacity/Powers of Attorney</p>';}
    //if ($i>12){echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
     echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';
   
} else {                         
	           // if (($i==1) and ($Phase == 7)) { echo '<p id="cat1" class="programHeader">The Role of Insurance in Family Wealth Management</p>'; }
                    //if (($i==1) and ($Phase ==11)) { echo '<p id="cat1" class="programHeader">&nbsp;</p>'; }
                    if (($i==1) and ($Phase ==10)) { echo '<p id="cat1" class="programHeader">Individuals</p>'; }
                    if (($i==1) and ($Phase ==9)) { echo '<p id="cat1" class="programHeader">Transitions: Boomers</p>'; }
	            if (($i==1) and ($Phase ==8)) { echo '<p id="cat1" class="programHeader">Accumulation and Growth: Ethical Investing</p>'; }
	                if ($i<6) {
	                    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';
	                    }
	           // if (($i==6) and ($Phase ==7)) { echo '<p id="cat2" class="programHeader">Managing Risks to Personal Assets</p>'; }
                    //if (($i==6) and ($Phase ==11)) { echo '<p id="cat1" class="programHeader">&nbsp;</p>'; }
                    if (($i==6) and ($Phase ==10)) { echo '<p id="cat1" class="programHeader">Business Owners</p>'; }                           
                    if (($i==6) and ($Phase ==9)) { echo '<p id="cat2" class="programHeader">Transitions: Millennials</p>'; }
	            if (($i==6) and ($Phase ==8)) { echo '<p id="cat2" class="programHeader">Preservation: Continuity Planning</p>'; }
	                if ($i>5 && $i<11) {
	                    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';
	                }
	           // if (($i==11) and ($Phase ==7)) { echo '<p id="cat3" class="programHeader">Managing Risk to People</p>'; }
                    //if (($i==11) and ($Phase ==11)) { echo '<p id="cat1" class="programHeader">&nbsp;</p>'; }
                    if (($i==11) and ($Phase ==10)) { echo '<p id="cat1" class="programHeader">Successors</p>'; }
	            if (($i==11) and ($Phase ==9)) { echo '<p id="cat3" class="programHeader">Transitions: Self-Employed</p>'; }
                    if (($i==11) and ($Phase ==8)) { echo '<p id="cat3" class="programHeader">Transition: Philanthropy and Estate</p>'; }
	                if ($i>10) {
	                    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';
	                }  
}                        
	        } else {
//set the flow for phase 11, otherwise follow below
                    
if ($Phase>11) {
    if ($i==1) {echo '<p id="cat1" class="programHeader">Module Series</p>';}
    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink"><a href="programs.php?m=' . $rs->Fields("fldProductID")->value . '">Module Description</a></div></div>';
} elseif ($Phase===11) {
    //do phase 11 stuff
    //Group 1 (Individuals: 4 modules [MGF1101, MGF1110, MGF1111, MGF1112)
    if ($i==1) {echo '<p id="cat1" class="programHeader">Individuals</p>';}
    if ($i==5) {echo '<p id="cat1" class="programHeader">Real Estate</p>';}
    if ($i==8) {echo '<p id="cat1" class="programHeader">Small Business</p>';}
    if ($i==13) {echo '<p id="cat1" class="programHeader">Incapacity/Powers of Attorney</p>';}

    //if ($i==1) {echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //if ($i>9 and $i<13){echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //Group 2 (Real Estate: 3 modules [MGF1102,MGF1103,MGF1104]
    //if ($i==2) {echo '<p id="cat1" class="programHeader">Real Estate</p>';}
    //if ($i>1 and $i<5) {echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //Group 3 (Small Business: 5 modules [MGF1105,MGF1106,MGF1107,MGF1108,MGF1109]
    //if ($i==5) {echo '<p id="cat1" class="programHeader">Small Business</p>';}
    //if ($i>4 and $i<10) {echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    //Group 4 (Incapacity/Powers of Attorney [MGF1113,MGF1114,MGF1115]
    //if ($i==13) {echo '<p id="cat1" class="programHeader">Incapacity/Powers of Attorney</p>';}
    //if ($i>12){echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink">' . $linktext . '</div><div class="programMark">'.$mark.'</div></div>';}
    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink"><a href="programs.php?m=' . $rs->Fields("fldProductID")->value . '">Module Description</a></div></div>';
} else {	         
//	           // if (($i==1) and ($Phase ==7)) { echo '<p id="cat1" class="programHeader">The Role of Insurance in Family Wealth Management</p>'; }
//                    //if (($i==1) and ($Phase ==11)) { echo '<p id="cat1" class="programHeader">&nbsp;</p>'; }
//                    if (($i==1) and ($Phase ==10)) { echo '<p id="cat1" class="programHeader">Individuals</p>'; }                    
//	            if (($i==1) and ($Phase ==9)) { echo '<p id="cat1" class="programHeader">Transitions: Boomers</p>'; }
//                    if (($i==1) and ($Phase ==8)) { echo '<p id="cat1" class="programHeader">Accumulation and Growth: Ethical Investing</p>'; }
//	                if ($i<6) {
//	                    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink"><a href="programs.php?m=' . $rs->Fields("fldProductID")->value . '">Module Description</a></div></div>';
//	                }
//	           // if (($i==6) and ($Phase ==7)) { echo '<p id="cat2" class="programHeader">Managing Risks to Personal Assets</p>'; }
//                    //if (($i==6) and ($Phase ==11)) { echo '<p id="cat1" class="programHeader">&nbsp;</p>'; }
//                    if (($i==6) and ($Phase ==10)) { echo '<p id="cat1" class="programHeader">Business Owners</p>'; }  
//	            if (($i==6) and ($Phase ==9)) { echo '<p id="cat2" class="programHeader">Transitions: Millennials</p>'; }
//                    if (($i==6) and ($Phase ==8)) { echo '<p id="cat2" class="programHeader">Preservation: Continuity Planning</p>'; }
//	                if ($i>5 && $i<11) {
//	                    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink"><a href="programs.php?m=' . $rs->Fields("fldProductID")->value . '">Module Description</a></div></div>';
//	                    
//	                }
//	          //  if (($i==11) and ($Phase ==7)) { echo '<p id="cat3" class="programHeader">Managing Risk to People</p>'; }
//                    //if (($i==11) and ($Phase ==11)) { echo '<p id="cat1" class="programHeader">&nbsp;</p>'; }
//                    if (($i==11) and ($Phase ==10)) { echo '<p id="cat1" class="programHeader">Successors</p>'; }   
//	            if (($i==11) and ($Phase ==9)) { echo '<p id="cat3" class="programHeader">Transitions: Self-Employed</p>'; }
//                    if (($i==11) and ($Phase ==8)) { echo '<p id="cat3" class="programHeader">Transition: Philanthropy and Estate</p>'; }
//	                if ($i>10) {
//	                    echo '<div class="programList">Module ' . $i . ': <b>' . $rs->Fields("fldProductName")->value . '</b><div class="programLink"><a href="programs.php?m=' . $rs->Fields("fldProductID")->value . '">Module Description</a></div></div>';
//	                    
//	                } 
}                        
	        }
	
	            $i++;
	        $rs->MoveNext();
	
	    }

}
//               
$conn->Close();
               
               
           } 
           
           
           
           //open db
           //get course descriptions: SELECT fldProductName, fldProductid FROM tblProduct WHERE LEFT(fldPublisher,2) = 'T4' AND fldCategoryid=12 ORDER BY [fldPublisher]
           // list courses by program 0-4=1, 5-9=2, 10-14=3
           ?>
                
                
                            </div>