August 6th, 2004, 04:32 AM
|
|
|
|
Join Date: Apr 2007
Posts: 8
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
ULTIMATE PAGINATION CHALLENGE
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:
Code:
<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:
Code:
$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
casey@martincreations.com
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
