[SOLVED] return query pagination

DarkPrince2005 · September 11, 2007

The attached code is suppose to query a database and return records between two dates and update the pagination links.

It works at first, but as soon as I click on a pagination link it re-queries the database and returns all of the records.

Can somebody please advise me how to resolve this problem.

<?php

mysql_connect("localhost","root","");

mysql_select_db("npa");

$perpage = 1;

$lynx = $html = "";

$startat = $_REQUEST

* $perpage;

$q = mysql_query("select count(File_Ref) from dis where Date_Recieved between '$_POST[date1]' and curdate()");

$row = mysql_fetch_array($q);

$pages = ($row[0] + $perpage - 1) / $perpage;

$q = mysql_query("select * from dis where Date_Recieved between '$_POST[date1]' and curdate() order by File_Ref desc limit $startat,$perpage");

while ($row = mysql_fetch_assoc($q)) {

$text = strip_tags($row[entry_text]);

$text = substr($text,0,300);

$html .= "<center><form>

<tr><td><b>Employee Firstname</td><td> </td>

<td>$row[Employee_Firstname]</td></tr>

<tr><td><b>Employee Lastname</td><td> </td>

<td>$row[Employee_Lastname]</td></tr>

<tr><td><b>Persal Number</td><td> </td>

<td>$row[Persal_Number]</td></tr>

<tr><td><b>Occupation</td><td> </td>

<td>$row[Occupation]</td</tr>

<tr><td><b>Level</td><td> </td>

<td>$row[Level]</td</tr>

<tr><td><b>Gender</td><td> </td>

<td>$row[Gender]</td</tr>

<tr><td><b>Suspension</td><td> </td>

<td>$row[suspensions]</td</tr>

<tr><td><b>Period</td><td> </td>

<td>$row[Period]</td></tr>

<tr><td><b>Date Recieved</td><td> </td>

<td>$row[Date_Recieved]</td</tr>

<tr><td><b>Region</td><td> </td>

<td>$row[Region]</td</tr>

<tr><td><b>Status</td><td> </td>

<td>$row[status]</td</tr>

<tr><td><b>Category</td><td> </td>

<td>$row[Category]</td></tr>

<tr><td><b>Outcome</td><td> </td>

<td>$row[Outcome]</td></tr></table></td><td> </td><td valign='top'><table width='400'>

<tr><td valign='top'><b>Status Report</td><td> </td>

<td width='250'>$row[status_Report]</td></tr>

</table></table>

</form>";

};

echo "$r";

for ($k=0; $k<$pages; $k++) {

if ($k != $_REQUEST

) {

$lynx .= " <a href=$PHP_SELF"."?page=$k>".($k+1)."</a>";

} else {

$lynx .= " <b>--".($k+1)."--</b>";

}

?>

<style>

a:link{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

text-decoration:none;

}

a:visited{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

text-decoration:None;

}

a:hover{font-family:'Times New Roman';

font-size:10pt;

text-decoration:none;

color:'#B37A04';

font-weight:700;

}

a:active{font-family:'Times New Roman';

font-size:10pt;

color:'#ffffff';

font-weight:700;

}

</style></head><body bgcolor='#FDCC67' topmargin='0' bottommargin='0' leftmargin='0' rightmargin='0'>

<a href='viewdate.php'>View Records</a><br><br>

<a href='add.html'>Add Record</a><br><br>

<a href='edit1.php'>Edit Record</a><br><br>

<a href='deletedate.php'>Delete Record</a><br><br>

<a href='report.php'>View Report</a><br><br>

<a href='q.php'>Query Report</a><br><br>

<a href="search1.php">Search</a></td><td valign="top" align="center"><table><tr>

<td align="right" valign="top"><form action="search2.php" method="post"><b>Search by Persal Number or Employee Lastname:</b> <input type="text" name="search"> <input type="submit" value="Search"></form></td></tr>

<tr><td align="center" valign="top"><h1>View Disciplinary Records</h1></td></tr>

</body>

Sign In

[SOLVED] return query pagination

Recommended Posts

DarkPrince2005

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information