没有页面显示时如何隐藏下一个按钮

Question

Can someone help me please? I am sure it is easy for you guys. I am battling to find a solution on how to hide the next link when there are no pages to display my code is as follows:

if (!isset($_GET['page']) or !is_numeric($_GET['page'])) {
    $page = 0;
} else {
    $page = (int)$_GET['page'];
}
$pages_query=mysql_query ("SELECT COUNT * FROM hardware");
$result = mysql_query("SELECT * FROM hardware LIMIT $page, 3");
echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.($page+3).'">Next</a><p>';
$prev = $page - 3;

//only print a "Previous" link if a "Next" was clicked
if ($prev >= 0) {
    echo '<a href="'.$_SERVER['PHP_SELF'].'?page='.$prev.'">Previous</a>';

}

Answer 1

You can use mysql_num_rows($result) to get the number of records in hardware:

$result = mysql_query("SELECT * FROM hardware LIMIT $page, 3");
$record_count =  mysql_num_rows($result);
if ($record_count > 1)
    echo 'Next';