<? require_once("../includes/main.inc.php");

$headerTitleName = "State Gallary Images List";

/**for  delete  groups **/



if($_REQUEST['action']=='delete'){

	 $page_id=$_GET['page_id'];

	 $sql8 = "delete from `tbl_county_gallery` where id in ($page_id)";

	 
	 db_query($sql8);

	 set_session_msg("Selected County Gallery Images and Related Data have been deleted successfully");

			

	header("Location: ".$_SERVER['HTTP_REFERER']);

	exit;

}

$start = intval($start);
$pagesize = intval($pagesize)==0?$pagesize=50:$pagesize;

$columns = "select * ";
$sql = " from `tbl_county_gallery` ";
$sql .= " where 1 ";
$order_by == '' ? $order_by = '`tbl_county_gallery`.id' : true;
$order_by2 == '' ? $order_by2 = 'ASC' : true;
$sql_count = "select count(*) ".$sql; 
$sql .= "order by $order_by $order_by2 ";
$sql .= "limit $start, $pagesize ";
$sql = $columns.$sql;
$result = db_query($sql);
$reccnt = db_scalar($sql_count);

?><link href="styles.css" rel="stylesheet" type="text/css">

<? include("top.inc.php");?>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td id="pageHead"><div id="txtPageHead">

    Manage County Gallery Images</div></td>

  </tr>

</table>

		<table width="100%" border="0" cellspacing="0" cellpadding="0">



  <tr>



    <td id="content">



        <div align="center"><span class="msg"><?=display_sess_msg();?></span></div><br />





        <a href="county_gallery_add.php?page_id=&start=0" class="redcolor">Add New State Gallery Images</a>

      <? if(mysql_num_rows($result)==0){?>

      

      <div class="msg">Sorry, no records found.</div>

      

      <? } else{ ?>

      <div align="right"> Showing Records: <?= $start+1?> to   <?=($reccnt<$start+$pagesize)?($reccnt-$start):($start+$pagesize)?>    of   <?=$reccnt?> </div>

      <form method="post" name="form1" id="form1" onSubmit="confirm_submit(this)">



        <table width="100%"  border="0" cellpadding="0" cellspacing="1" class="tableList">

          <tr>

          <th  align="center" width="5%">SL</th>

          <th  align="left" width="25%" style="padding-left:10px;">County Gallery Images</th>

          <th  align="left" width="15%" style="padding-left:10px;">County Gallery Id</th>
		  
		   <th  align="left" width="15%" style="padding-left:10px;">County Name</th>

          <th  align="center" width="8%">Status</th>

         <!-- <th align="center" width="8%">Edit</th>-->

          <th align="center" width="5%">Delete</th>

          </tr>

      <? 

if($start==0){

	$cnt=0;

}

else{

	$cnt=$start;

}

while ($line_raw = mysql_fetch_array($result)) {

	$cnt++;

$line = ms_display_value($line_raw);

@extract($line);

$css = ($css=='trOdd')?'trEven':'trOdd';

?><tr class="<?=$css?>">

<td  valign="top" align="center"><?=stripslashes($id)?></td>

<td align="left" valign="middle" style="padding-left:10px;"><?=stripslashes($county_gallery_name)?></td>

<td align="left" valign="middle" style="padding-left:10px;"><?=stripslashes($county_gallery_id)?></td>

<td align="left" valign="middle" style="padding-left:10px;"><?=stripslashes($county_name)?></td>


<td align="center" valign="middle"><?php if($status=='1'){ echo 'Active'; }else{ echo '<span style="color:red;">InActive</span>'; } ?></td>


<!--<td align="center" valign="top"><a href="county_gallery_add.php?page_id=<?=$id?>&start=<?=$start?>"><img src="images/icons/edit.png" alt="Edit" width="16" height="16" border="0" /></a></td>-->



<td align="center" valign="top"><a href="county_gallery.php?page_id=<?=$id?>&start=<?=$start?>&action=delete" onclick="return stdel_confirm();"><img src="images/icons/trash-20.png" alt="Edit" width="16" height="16" border="0" /></a></td>

</tr>

<? }?>        </table>

 </form>

<? }?>

 <? include("paging.inc.php");?>    </td>



  </tr>



</table>

<script>

function stdel_confirm(){  return confirm("Are you sure want to delete?"); }

</script>

<? include("bottom.inc.php");?>