0

hi,
this is my php code
i need pagination for this page..
help me please....

include('connection.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <meta http-equiv="Expires" content="Wed, 01 Jan 2020 00:00:01 GMT" />
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta http-equiv="Content-Script-Type" content="text/javascript" />
        <meta name="description" content="Generated by Justinmind on Wed Dec 01 20:19:32 CST 2010" />
        <title>ContractManagement_1 - ContractManagement_PurchaseSalesChoice</title>
	  	<script>
        function redirectPage()
            {
                window.location = "logout.php";
            }
        </script>
		<script>
        function helpPage()
            {
                window.location = "accounts_help.php";
            }
        </script>
    </head>
    <body>
        <div id="s-90633959-3d7d-4b7a-ad54-f115555e0ed3">
            <input id="screenName" type="hidden" value="ContractManagement_PurchaseSalesChoice" />
            <input id="canvases" type="hidden" value="s-90633959-3d7d-4b7a-ad54-f115555e0ed3?t-54111db7-a054-4a0b-a1aa-0177946a18ee" />
            <link type="text/css" rel="stylesheet" href="/brando/css/screens/accounts.css" charset="UTF-8" />
		    <link type="text/css" rel="stylesheet" href="/brando/css/screens/style.css" charset="UTF-8" />
            <link type="text/css" rel="stylesheet" href="/brando/css/templates/Template 1.css" charset="UTF-8" />
            <!--[if IE]>
            <link type="text/css" rel="stylesheet" href="./css/screens/Financing_bank.css-ie.css" charset="UTF-8" />
            <link type="text/css" rel="stylesheet" href="./css/templates/Template 1-ie.css" charset="UTF-8" />
            <![endif]-->
	    <div class="t-54111db7-a054-4a0b-a1aa-0177946a18ee template trigger commentable"></div>
		<div class="s-90633959-3d7d-4b7a-ad54-f115555e0ed3 screen trigger commentable">	
        <div id="s-Group_3">
		<div id="s-Rectangle_1" class="rectangle trigger commentable" >
		<img id="s-Image_1" class="image trigger commentable"   alt="image" src="/brando/images/0- stratechon clear logo-01.png" />
		<div id="s-Group_2">
		<div id="s-Button_1" class="label trigger commentable" ><input type="button"  value="BACK" name="back" id="s-Button_1" class="label trigger commentable" onclick="history.back()"/></div>
			  <div id="s-Button_2" class="label trigger commentable" ><input type="button" value="FORWARD" name="forward" id="s-Button_1"  onclick="history.forward()"/></div>
			  <div id="s-Button_3" class="label trigger commentable" >TOOLS</div>
              <div class="label trigger commentable"><input id="s-Button_4" type="button" value="HELP" onclick="helpPage()"/></div>
			  <div  class="label trigger commentable"><input id="s-Button_5" type="button" value="LOGOUT"onclick="redirectPage()"/></div>
           </div>
           <div id="s-Label_1" class="label trigger commentable" >Enterprise Management Tool</div></div>
		   <div id="s-login_name" class="label trigger commentable" ><?php echo '" '. $_SESSION['name'].' "'; ?></div>
		   <div id="s-loginas" class="label trigger commentable" >Login As</div>
		   <div id="s-Rectangle_3" class="rectangle trigger commentable" >
		   <div id="s-Label_7" class="label trigger commentable" >Accounts</div></div>
		   <div id="s-Group_4">
			<div  class="label trigger commentable" ><a href="javascript:window.print()"><input id="s-print" type="button" value="Print"></a></div>
		    <a href="mailto:asdf@gmail.com"><div id="s-mail" class="label trigger commentable">Send E-mail</div></a></div>
		    <div id="s-Rectangle_4" class="rectangle trigger commentable" ></div>
		    <div id="rect_main_data" class="rectangle trigger commentable" >
			<div id="s-Rectangle_5" class="rectangle trigger commentable" >
              <table style="border: thin groove #000000; width: 98%; height: 25px; position: absolute; left: 10px; top: 20px;">
              <tr>
                <td align="center" class="style1" style="background-color: #C0C0C0">BROKER</td>                 
                <td align="center" class="style1" style="background-color: #C0C0C0">ACCOUNT NO:</td>   
                <td align="center" class="style1" style="background-color: #C0C0C0">AMOUNT</td>              
                <td align="center" class="style1" style="background-color: #C0C0C0">FINANCING BANK</td>                
			  </tr>
				
		    <?php
	            $sql="select `M_BROKER`.`MBRO_NAME`,`M_ACCOUNT`.`MACC_NO`, `M_BANK`.`MBAN_NAME` from M_BANK, M_ACCOUNT,M_BROKER where `M_BROKER`.`PK_MBRO_ID`=`M_ACCOUNT`.`FK_PK_MBRO_ID` and `M_ACCOUNT`.`FK_PK_MBAN_ID`=`M_BANK`.`PK_MBAN_ID`";
			    $rec=mysql_query($sql,$con);
			    while($row=mysql_fetch_row($rec))
                {
                    echo "<tr>";
                    echo "<td class='style3'style='border: thin groove #000000; background-color: #FFFFFF' align='center'>".$row[0]." &nbsp;</td>";
		            echo "<td class='style3'style='border: thin groove #000000; background-color: #FFFFFF' align='center'>".$row[1]." &nbsp;</td>";
		            ?>
		                <td class="style3"style="border: thin groove #000000; background-color: #FFFFFF" align="center">&nbsp;</td>
		            <?php
		                echo "<td class='style3'style='border: thin groove #000000; background-color: #FFFFFF' align='center'><a href='financing_bank.php?name=".$row[2]." 'style='text-decoration:none'>".$row[2]." &nbsp;</a></td>";
		                echo "</tr>";
		        }
            ?> 
            </table>			
            </div>
		   </div>
		 </div>
        </div>
    </body>
  </html>
2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by pritaeas
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.