</tr>

          <tr bgcolor="#000000">
            
            <td  class="style3" height="25" align="left" >Branch</td>
            <td  class="style3" height="25" align="left"  >Sub Branch</td>
			<td  class="style3" height="25" align="center"   width="100" nowrap="nowrap"> Action</td>
          </tr>
             <?php 
$row_count = 1;
$SQL_Query = "SELECT * FROM tbl_sub_branches order by branch_id";
$result = mysql_query($SQL_Query);
$count = mysql_num_rows($result);
if ($count != 0) {
    $pager = new PS_Pagination($conn, $SQL_Query, 10, 200, "");
    $pager->setDebug(true);
    $rs = $pager->paginate();
    while ($row_user = mysql_fetch_assoc($rs)) {
        $sql_branch = "select branch_name from tbl_branch_master where  branch_id=" . $row_user['branch_id'];
        $result_branch = mysql_query($sql_branch);
        $row_branch = mysql_fetch_assoc($result_branch);
        ?>
           
		 <tr height="20"<?php 
        if ($row_count % 2 == 0) {
            echo 'bgcolor="#F7F7F7"';
        }
        ?>
 >
         
Esempio n. 2
0
		<tr>
		<td align ='center' valign ='top' class='table_text error'>
		<?php 
if (isset($_COOKIE['msg'])) {
    echo $_COOKIE['msg'];
    setcookie('msg', '');
}
?>
		</td>
		</tr>
		<tr>
			<td valign ='top' align ='left'>
			<?php 
$sql = "SELECT id,page_name,templates_id,created_on,upload_url FROM sp_squeeze_pages_1 WHERE users_id='" . $user_session_id . "' UNION SELECT id,page_name,templates_id,created_on,upload_url FROM sp_squeeze_pages_2 WHERE users_id='" . $user_session_id . "' UNION SELECT id,page_name,templates_id,created_on,upload_url FROM sp_squeeze_pages_3 WHERE users_id='" . $user_session_id . "' UNION SELECT id,page_name,templates_id,created_on,upload_url FROM sp_squeeze_pages_4 WHERE users_id='" . $user_session_id . "' ORDER BY templates_id,id DESC";
$pager = new PS_Pagination($conn, $sql, REC_PER_PAGE, SHOW_PAGES, "");
$pager->setDebug(false);
$rs = $pager->paginate();
if ($rs) {
    echo "<table border='0' cellspacing='0' cellpadding='0' width='99%'>";
    //echo "<tr><td colspan ='6' align ='left' valign ='top' class='table_text'><b>Template ".$templates_id." Total Record : " . $totalRecords . "</b></td></tr>";
    echo "<tr class='tableHeader'  height='25'><td align ='center' valign ='top' class='largewhite'>No.</td><td class='largewhite' align ='center' valign ='top'>View Page</td><td class='largewhite' align ='left'>Page Name</td><td class='largewhite' align ='left' valign ='top'>Created On</td><td class='largewhite' align ='center' valign ='top'>Edit</td><td class='largewhite' align ='center' valign ='top'>Delete</span></td></tr>";
    $counter = 0;
    $temp_template = "";
    while ($row = mysql_fetch_assoc($rs)) {
        $id = $row['id'];
        $page_name = ucfirst(strtolower($row['page_name']));
        $templates_id = $row['templates_id'];
        $uploadURL = $row['upload_url'];
        if ($uploadURL != "") {
            $pageTitle = "<a href ='{$uploadURL}' target ='_blank' title ='click to view the uploaded page'>{$page_name}</a>";
        } else {