link problem [1][2]-----

zuzupus

hi,

form below piece of code i try to get the next page when 3 rows shown in table ,once user enter 4th row he will get page [1][2][3]
...and so on same liek this forum
so i jsut counted the rows from table t_emp where user

$Qpages=mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM t_emp WHERE user = $session->sys_pk"));
$pages=ceil($Qpages[0]);
 $offset=($HTTP_GET_VARS["page"]*3)-3;
$result = mysql_query("	SELECT
		bah balh from
           t_emp order by id DESC LIMIT $offset,3");
then here is some problem 
<? for ($i=3; $i<=$pages; $i++) echo "<left><a href=test.phtml?page=$i> [$i] </a>&nbsp";?>
as now what happening once user submit the form it shows [1] [2] [3] and so on

if anybody figure it out be appreciated and anything not able to understand plz let me know

regards

nelustr

Just an example:

http://www.xtrax.ro/php/pagelink/index.php?iPage=3

<?php
session_start();
session_register("is_logged","nRecords","nPages","recordPage");
if (!isset($GLOBALS["is_logged"])){
   echo "xxx";
	 $is_logged=1;
	 $recordPage=3; // records/page 
	 // nRecords: number of records from the selected table
	 // iPage   : current page
	 // nPage   : number of pages
   $recordPage=2; // number of records/page
   require ("config.inc.php"); // connecting to the database
   $result = mysql_query("SELECT count(*) AS nRecords FROM links");
	 $aResult  = mysql_fetch_array($result);
   $nRecords = $aResult["nRecords"];
	 $iPage  = 1;
	 $nPages = intval($nRecords/$recordPage);
	 if ($nPages*$recordPage<$nRecords) $nPages=$nPages+1; 
 }
?>
<form method="GET">
<center>
<?php
echo "<B><U>Check the variables</U></B><BR />";
echo "<B><U>nRecords:</U></B>$nRecords  : number of records from the selected table<BR />";
echo "<B><U>nPages  :</U></B>$nPages : number of pages<BR />";
echo "<B><U>iPage   :</U></B>$iPage : current page<BR />";
echo "<center><table align=center border=1>";
require ("config.inc.php"); // connecting to the database
$offset=($iPage-1)*$recordPage;
$result = mysql_query("SELECT * FROM links LIMIT $offset, $recordPage");
$nResult = mysql_num_rows($result);
for ($counter=0;$counter<$nResult;$counter++){
		$aResult = mysql_fetch_array($result);
		$id      = $aResult["id"];
		$info    = $aResult["info"];
		echo "<tr><td align=center>$id</td><td align=center>$info</td></tr>\n";
    }

echo "<BR /><center>";
for ($iCount=1;$iCount<=$nPages;$iCount++){
    if ($iCount==$iPage) $theLink="<B>$iCount</B>";
		else								 $theLink=$iCount;                          

  	echo "<a href=$PHP_SELF?iPage=$iCount>$theLink</a>\n";
		} 
echo "<center>";
?>
</table>
</form>

stolzyboy

use the search link for cgraz or pagination on this board, he has a good one to use

stolzyboy

oh well, did the work for ya, here it is:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10219415&highlight=display

nelustr

Sorry Mr. stolzyboy
I added bold fonts for your nick just because I saw that you are a moderator. Sorry for... my arguing...
May I ask you some questions?
If yes,
first one is: did you think that your last two "answers" are in respect of the "zuzupus" question?
I thinkNO
the second one is: did you answer to "zuzupus"?
I thinkNO
So...
I really don't like your... postion 🙂)
I think that if somebody

BuzzLY

Hear, hear, very well said. Did you hear that, Stolzy? He told you!

stolzyboy

Originally posted by nelustr
Sorry Mr. stolzyboy
I added bold fonts for your nick just because I saw that you are a moderator. Sorry for... my arguing...
May I ask you some questions?
If yes,
first one is: did you think that your last two "answers" are in respect of the "zuzupus" question?
I thinkNO
the second one is: did you answer to "zuzupus"?
I thinkNO
So...
I really don't like your... postion 🙂)
I think that if somebody

well ya see, he wants to do some, hmmm, pagination, so I sent him to some code that already had pagination done, and it is a really good example

and what is wrong with telling someone how to UTSL and STFW and RTFM

don't think you need to tell me how to answer questions

and if you actually follow the place i linked you to, you will find that i pointed you to a very nice resource

so is that wrong of me, i think not!

and this is bold

zuzupus

sorry all for late reply well i ty to fix by my own and tried to find simpler solution
$recs_per_page = 3;
$Qrecs=mysql_fetch_row(mysql_query("SELECT COUNT() FROM t_emp"));
$num_records = $Qrecs[0];
$num_pages = ceil($num_records / $recs_per_page);
if($num_pages == 0) { $num_pages = 1; }
echo("Records:$num_records Pages:$num_pages ");
$page = isset($HTTP_GET_VARS["page"])?$HTTP_GET_VARS["page"]:0;
$page = preg_replace('/D/','',$page);
if($page < 1) { $page = 1; }
if($page > $num_pages) { $page = $num_pages; }
$offset = ($page - 1) $recs_per_page;
echo("Page:$page Offset:$offset ");
it works fine but dont no how to get 1[2] in first page and second page must be [1]2
how to deal with this one

plz have a look at this

http://172.16.0.100/scripts/test.phtml

<?
if($num_pages > 1)
{
for ($i=1; $i<=$num_pages; $i++) echo "<left><a href=test.phtml?page=$i> [$i] </a> ";
}
?>

regards