Previous/Next Links with MySQL

intermediate

I'm trying to get my Previous/Next links to work, please help!

Here is my current code:

<?php
function showData() {
if (!$num) {
  $num = 0;
} 

$host = "";
$user = "";
$pw = "";
$database = "";
$table = "";

$db = mysql_connect($host, $user, $pw);
mysql_select_db($database, $db) or die("Cant Connect to Database");
$requete = "select * from $table limit $num,10";
$result = mysql_query($requete, $db);
$get = mysql_num_rows($result);
if ($get > 0) {
while ($row = mysql_fetch_object($result)) {

print <<<END
<tr>
<td>$row->date</td>
<td>$row->quote</td>
<td>$row->username</td>
</tr>
END;
}
} else {
print <<<END
<center>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td align="center"><b>No Records Found</b></td>
</tr>
</table>
END;
}


$pnum = $num - 10;
$nnum = $num + 10;
print <<<END
<center>
<table cellpadding="0" cellspacing="0" border="0" width="80%">
<tr>
END;

if ($num > 0) {
print <<<END
<td align="center"><a href="maintest.php?num=$pnum">Previous 10</a></td>
END;
}
if ($num >= 0) {
print <<<END
<td>
<a href="maintest.php?num=$nnum">Next 10</a>
</td>
END;
}
}
?>
<html>
<head>
<title>Main</title>
</head>
<body>
<center><b>Quotes</b></center><br>
<center>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr bgcolor="#000000">
<td align="center"><b><font color="#FFFFFF">Last Updated</font></b></td>
<td align="center"><b><font color="#FFFFFF">Quote</font></b></td>
<td align="center"><b><font color="#FFFFFF">User</font></b></td>
</tr>
<?php showData(); ?>
</table>
</center>
<br>
<br>
</tr>
</table>
</center><br>
<center>
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td align="center"><a href="signupform.php">Signup</a></td>
<td align="center"><a href="logintest1.php">Login</a></td>
</tr>
</table>
</center>
</body>
</html>

Thanx in advance for any help you give!

jeremuck

what happens?

from a basic look, the value $num will always be unset, or equal the default zero whenevery you call the function, because you haven't passed it in.

The link will give the page whatever value $num is set to in GET method. Depending on your PHP settings, you will need to access it like: $_GET['num'];

I suggest changing the function signature to:

function showData($num = 0)

and then deleting that first if statement.

When you call the function, do so like this:

showData($_GET['num']);