Search the Community
Showing results for tags 'last record error'.
Found 1 result
-
Hello , I am stuck trying to get this code to work, every thing works well untill you try to go to the last record or a negtive - number in the records. ------------------------------------------------------- <?php include('conect.php'); $page = (isset($_GET['page'])) ? $_GET['page'] : 1; $startPoint = $page - 1; $data = "SELECT * FROM table1 ORDER BY id ASC LIMIT $startPoint,1"; $query = mysql_query($data); $data2 = mysql_fetch_array($query); $rowCount = 0; ?><HTML><HEAD><TITLE></TITLE><META content="text/html; charset=utf-8" http-equiv=Content-Type><META name=GENERATOR content="MSHTML 9.00.8112.16457"><STYLE type=text/css>BODY { FONT-FAMILY: verdana, arial, sans-serif }</STYLE></HEAD><BODY> <P></P> <P> <FORM method=post action=display4.php> <P></P> <P></P> Name: <INPUT value="<?php echo $data2[a]?>"> <INPUT value="<?php echo $data2[b]?>"> <INPUT value="<?php echo $data2[c]?>"><BR> Club: <BR> hobby: <P><INPUT style="Z-INDEX: 132; POSITION: absolute; TOP: 67px; LEFT: 151px" value="<?php echo $data2[id]?>"> <P><INPUT style="Z-INDEX: 132; POSITION: absolute; TOP: 66px; LEFT: 313px" value="<?php echo $data2[timenow]?>"> <P><BR> </P> <A href="display4.php?page=1">First</A> <A href="display4.php?page=<?php echo $page - 1?>">Prev</A> <A href="display4.php?page=<?php echo $page + 1?>">Next</A> <A href="display4.php?page=<??>hp echo $rowCount?;">Last</A> </FORM> <P></P></BODY></HTML> I am thinking its something to do with this line $data = "SELECT * FROM table1 ORDER BY id ASC LIMIT $startPoint,1"; any help please ? thanks.
