</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"'; } ?> >
<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 {