</td> </tr> <tr align="center" valign="middle"> <td colspan="5"> <?php if ($maxPage > 1) { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="35%" style="border-right:none;"> </td> <td width="40%" align="center" valign="middle" style="border-right:none;"><?php echo $pager->renderPrev('Previous'); ?> <?php echo $pager->renderNav('<span>', '</span>'); ?> <?php echo $pager->renderNext('Next'); ?> </td> <td width="25%" style="border-right:none;"> </td> </tr> </table> <?php } ?> </td> </tr> </table>
<td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> --> <tr> <td colspan="5" align="center" valign="middle"><?php if($maxPage>1) { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="35%" style="border-right:none;"> </td> <td width="40%" align="center" valign="middle" style="border-right:none;"><?php echo $pager->renderFirst('First');?> <?php echo $pager->renderPrev('Previous');?> <?php echo $pager->renderNav('<span>', '</span>');?> <?php echo $pager->renderNext('Next'); ?> <?php echo $pager->renderLast('Last'); ?></td> <td width="25%" style="border-right:none;"> </td> </tr> </table> <?php } ?> </td> <td> </td> </tr> </table> </div><p> </p> </div> </body>
<?php include 'ps_pagination.php'; $conn = mysql_connect('localhost', 'root', ''); mysql_select_db('hawthorne_nittany', $conn); $currdate = date("m/d/Y"); $sql = "SELECT * FROM `admin_rfq` WHERE isvalid=1"; $result = mysql_query($sql); $pager = new PS_Pagination($conn, $sql, 20, 5); //The paginate() function returns a mysql result set $rs = $pager->paginate(); if (mysql_num_rows($result) > 20) { echo " " . $pager->renderFirst('First') . " "; //Display the link to previous page: << echo $pager->renderPrev('<<'); //Display page links: 1 2 3 echo $pager->renderNav(); //Display the link to next page: >> echo $pager->renderNext(' >>'); //Display the link to last page: Last echo " " . $pager->renderLast('Last'); } ?> </td> </tr> <tr valign="top"> <td class="heading" width="5%">Sl.No</td> <td class="heading" width="7%">RFQ Id</td> <td class="heading" width="30%">Title</td> <td class="heading" >Description</td>