Ultimate Pagination Challenge

[cmarti]

I've got a challenge for everyone. The are a lot of pagination scripts out there, but none that do what I am looking for. I've got a MySQL database with two tables (User_Info and GradeBook). User_Info includes StuID and Password. GradeBook includes StuId, Assignment, and Grade. Each student has multiple grades. I'm willing to pay $20 dollars (sorry, that's all I have), to anyone who can help.

On one page (body) I have a form:

<form action="StuGetIn.php" method="POST">
Student ID: <input type="text" name="StuUserID" size="14">
Password: <input type="password" name="StudPassword" size="14">
<input type="image" src="../Images/Go.gif"></form>

The query for the StuGetIn.php page that I would like to use is:

$username = $_POST["StuUserID"];
$password = $_POST["StudPassword"];
select * from User_Info, GradeBook 
where User_Info.stuID=GradeBook.stuID 
AND User_Info.StuID='$username'and User_Info.Password='$password' 
ORDER BY DatePosted DESC, ClassName DESC

With that said, I would like a simple working pagination (previous/next) script that checks the values from the form against the database and displays 5 results per page.

Please help.
-Casey
[e-mail]

[planetsim]

Like you said there are lots of these scripts on the net. Why dont you find one you like modify it slightly to have a session record the information from the form to session then use that on each Page.

[cmarti]

Thanks planetsim,
I figured it out.