[SOLVED] Pagination lynx

DarkPrince2005 · September 20, 2007

Attached is the code for a page that goes through the database and creates pagination lynx on the page. but it only seems to work when i run it on my pc, but as soon as i upload it it only displays the first record and not the pagination lynx.........please help

<?php

$con=mysql_connect("localhost","root","");

if (!$con)

{

die('Could not connect: ' . mysql_error());

};

$con1=mysql_select_db("npa");

if (!$con1)

{

die('Could not connect: ' . mysql_error());

};

$perpage = 1;

$lynx = $html = "";

$startat = $_REQUEST

* $perpage;

$q = mysql_query("select count(File_Ref) from dis");

$row = mysql_fetch_array($q);

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

$r = mysql_query("SELECT Date_Recieved, CURDATE(), (YEAR(CURDATE())-YEAR(Date_Recieved)) - (RIGHT(CURDATE(),5)<RIGHT(Date_Recieved,5))");

$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='view.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='delete1.php'>Delete Record</a><br><br>

<a href='datereport.html'>View Report</a><br><br>

<a href='q.html'>Query Report</a><br><br></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 Last Name:</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] Pagination lynx

Recommended Posts

DarkPrince2005

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information