PHP - MySQL query

[Maya Naga]

hi ranches..
i have done application which retrieves result from mysql table according to user extension and date's..
i did pagination to display the result. i try to print the result as ' Showing 1-10 records of 100'.
but my problem is am getting same as '90-100 of 100 records' rather than '94-100 of 100 records ' though the page has only 6 records..
how to solve this problem...

i have attached my code..

        $rowsPerPage = '10';
        if(isset($_GET['page']))
        {
            $pageNum = $_GET['page'];
        }
        $offset = ($pageNum - 1) * $rowsPerPage;

$query="SELECT * FROM calldetail WHERE (";
                for($i=0;$i<count($r);$i++)
                {
                    if ($r[$i][1]==null)
                    {
                        if ($i>0)
                            $query.=" OR";
                        $query.=" (CallTermination ='".$r[$i][0]."')";
                    }
                    else
                    {
                        if ($i>0)
                            $query.=" OR";
                        $query.=" (CallTermination BETWEEN '".$r[$i][0]."' AND '".$r[$i][1]."')";
                    }
                }  // end of for loop
                $query.=") and CallFlag='L' AND CallDate BETWEEN '".$frmDate1."' AND '". $toDate1."' ORDER BY ";
                if ($dat=='CallDate desc' or $dat=='CallDate asc')
                    $query.=$dat;
                $query.=" LIMIT $offset, $rowsPerPage";
                $c1='&optDat';
                tab($query,$connection,$frmDate,$toDate,$incoming,$dat,$c1,$offset,$rowsPerPage,$pageNum,$row['CallFlag'],$dial,$receive);
                $query="SELECT count(CallDate) as numrows FROM calldetail WHERE (";
                for($i=0;$i<count($r);$i++) {
                    if ($r[$i][1]==null)
                    {
                        if ($i>0)
                            $query.=" OR";
                        $query.=" (CallTermination ='".$r[$i][0]."')";
                    }
                    else
                    {
                        if ($i>0)
                            $query.=" OR";
                        $query.=" (CallTermination BETWEEN ".$r[$i][0]." AND ".$r[$i][1].")";
                    }
                }    //end of for loop
                $query.=")and CallFlag='L' AND CallDate BETWEEN '".$frmDate1."' AND '". $toDate1."' ORDER BY CallTermination ASC";

                // how many rows we have in database

                $result  = mysql_query($query) or die('database query error, query failed');
                $row     = mysql_fetch_array($result, MYSQL_ASSOC);
                $numrows = $row['numrows'];
            }
                //echo $numrows;
                //echo "Total Records: " . $numrows . '<br/>';

                $maxPage = ceil($numrows/$rowsPerPage);
                

                $self = $_SERVER['PHP_SELF'];
                $nav = '';
                for($page = 1; $page <= $maxPage; $page++)
                {
                    if ($page == $pageNum)
                    {
                        $nav .= " $page ";   // no need to create a link to current page
                    }
                    else
                    {
                        $nav .= " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$page\">$page</a> ";
                    }
                }// end of for loop
                //echo "Total Pages:"  . $page;
                // creating previous and next link plus the link to go straight to the first and last page
                if ($pageNum > 1) {
                    //this is activated from page 2
                    $page = $pageNum - 1;
                    $prev = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$page\"><img style='border-style:none' src='img/previous.gif'></a> ";
                    $first = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=1\"><img style='border-style:none' src='img/firstenable.gif'></a> ";
                    //echo '<center>';
                    //echo $first . $prev;
                    //echo '<center/>';
                }
                else {
                    //this is for first page
                    $prev  = '<img style="border-style:none" src="img/previous.gif">'; //1st page; we're on page one, don't print previous link
                    $first = '<img style="border-style:none" src="img/firstdisable.gif">'; // nor the first page link
                }
                if ($pageNum < $maxPage) {
                    $page = $pageNum + 1;
                    $next = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$page\"><img style='border-style:none' src='img/next.gif'></a> ";
                    $last = " <a href=\"$self?beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&page=$maxPage\"><img style='border-style:none' src='img/lastenable.gif'></a> ";
                }
                else {
                    $next = '<img style="border-style:none" src="img/next.gif">'; // we're on the last page, don't print next link
                    $last = '<img style="border-style:none" src="img/lastdisable.gif">'; // nor the last page link
                }
                // print the navigation link
                echo '<br/><center>';
                echo $first . $prev . $next . $last;
                // and close the database connection
                echo "<p >" .'Showing <font color="red">'. ($offset+1) . " - " .  ($offset+$rowsPerPage) . "</font>   of   ". $numrows . " Records" ."</p>";
            }

thanks

[Maya Naga]

i have another issue.
how to pass variable values to next page using post method..
i have done using get method and am passing values such as:

echo "<a href=\"outgoing.php?optSingle=".$c."&beg=".$frmDate."&datEnd=".$toDate."&inTxt=".$incoming."&flr=".$flr."&page=1\" ></a>";

how to change to post method?
can please someone help me to solve above 2 issues?

[Maya Naga]

any one please give some idea on how to solve the above issues..
thanks

[R Srini]

Hello Ambika. This particular forum is for Web Services questions - hence no response to your query in the last few days. I would suggest you ask this in a PHP forum, e.g. in DevNetwork, then you will have a better chance of receiving a response to your question. Or at least they will point you to some appropriate tutorials.

Best of luck!