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
[php]
$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