Residential Properties
$rowsPerPage = 4;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$sql=mysql_query("select * from portfolio where status='Y' order by portfolio_id DESC limit $offset,$rowsPerPage") or die(mysql_error());
$query = "SELECT COUNT(portfolio_id) AS numrows FROM portfolio where status='Y'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = '';
?>
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= "
$page ";
}
else
{
$nav .= "
$page ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = "
«Previous ";
$first = "
[First Page] ";
}
else
{
$prev = ' ';
$first = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = "
Next» ";
$last = "
[Last Page] ";
}
else
{
$next = ' ';
$last = ' ';
}?>
=$nav;?>
while($res=mysql_fetch_array($sql)) { ?>
| |
=$res['name'];?> |
|
| Description: |
=stripslashes($res['desc']);?> |
| Location: |
=$res['loc'];?> |
} ?>