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!
