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]." </td>";
echo "<td class='style3'style='border: thin groove #000000; background-color: #FFFFFF' align='center'>".$row[1]." </td>";
?>
<td class="style3"style="border: thin groove #000000; background-color: #FFFFFF" align="center"> </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]." </a></td>";
echo "</tr>";
}
?>
</table>
</div>
</div>
</div>
</div>
</body>
</html>