<br>
<div class="container">
	<div class="row">
    
        <div class="col-lg-12 col-sm-12" >
        <img src="<?php echo SITEURL?>/images/bg2.jpg" alt=""  class="img-responsive image1">
        </div>
    </div>
</div>
					
        <div class="container" style="margin-top:50px; line-height:30px">
        <div class="row">           
       <div class="col-lg-12 col-sm-12 cls-overflow">
         <table class="table table-striped table-hover" width="100%" >
          	<thead>
            
            	<tr style="background-color:#A795C4;">
                	<th>sr.No</th>
                    <th>Purpose</th>	
                    <th>Date</th>
                    <th>Time</th>
                    <th>Venue</th>
                    <th>city</th>
                    <th>State</th>
 					<th>Presenter</th>                   
                </tr>
            </thead>
            <tbody>
            <?php
            	$sql = 'SELECT S.*,D.district as distName,St.state as stateName FROM '.$DB->pre.'seminar_sch as S
						LEFT JOIN '.$DB->pre.'state as St on S.state = St.stateID
						LEFT JOIN '.$DB->pre.'district as D on S.district = D.districtID 
						WHERE S.status="1" ORDER BY S.semID DESC';
				$S = $DB->dbRows($sql);
				$i = 1;
				foreach($S as $S){
					?>
                    <tr>
                	<th><?php echo $i?></th>
                    <td><?php echo $S['purpose']?></td>
                    <td><?php echo date('d-M-Y',strtotime($S['date']))?> </td>
                    <td><?php echo $S['time']?></td>
                    <td><?php echo $S['venue']?></td>
                    <td><?php echo $S['distName']?></td>
                    <td><?php echo $S['stateName']?></td>
                    <td><?php echo $S['presenter']?></td>
                    
                    
                </tr>
                    <?php
					$i++;
				}
				
			?>
            	
                
                
                
                
            </tbody>
         </table>
       
    </div> 
         </div>
       </div>
