calling the form itself

[chintupintu03]

Hi all,

Following is my query. I am taking the category_id as an input from the user. Depending upon the ID the query is generated. Multiple pages are shown, depending upon of records fetched. Presently I am showing 10 records per page.

Following is the partial code referring the above query.

$item_categ_id_v = $HTTP_POST_VARS['categ_id_v'];

This is the category ID received from first form, to retrieve the records.

When the number of records are more than 10, multiple pages are required.

To show the second page onward, ( or going backward) "Next" and "Prev" options are enabled.

Following line I am using to get the next set of records ( i.e. record numbers 11 - 20 )

print " <a href=\"$PHP_SELF?limit=$limit&&offset=$newoffset&&curr_page=$i&&item_categ_id_v=$item_categ_id_v\">$i</a> &nbsp ";

Here : offset is used to store number of records fetched from query, limit is used to store number of records to be displayed per page, curr_page is used to store current page number displayed, item_categ_id is the ID based on which query is formed.

But above "print" statement does not take category ID value. THe ID value is lost and all the records are fetched from the table. ( in other words, the where clause is not formed for second page onwards. )

Can anybody help me out?

Thanks in advance.

[echos]

To better help you, it would be benificial to replace the depracted constants in PHP.

so
$item_categ_id_v = $HTTP_POST_VARS['categ_id_v'];
should be
$item_categ_id_v = $_POST['categ_id_v'];

second
print " <a href=\"$PHP_SELF?limit=$limit&&offset=$newoffset&&curr_page=$i&&item_categ_id_v=$item_categ_id_v\">$i</a> &nbsp ";
should be
echo " <a href=\"". $_SERVER['PHP_SELF'] ."?limit=". $limit ."&&offset=". $newoffset ."&&curr_page=". $i ."&&item_categ_id_v=". $item_categ_id_v ."\">". $i ."</a> &nbsp ";

Even though you can put variables in "magic quotes" under some circumstances it's best to always treat them as variable and not part of quotes.

It also might be benificisal to test you $_POST vars to make sure that they are not empty or an undesired value.

[chintupintu03]

Hi echos,

Thanks for the reply. I made corrections as per your suggesions. Still the query generated is not proper for second page onwards. But there are some changes seen in the address bar. Previously no value was getting assgined to the variable passed. Right now it shows the category ID passed, but while making the"WHERE" clause in the query, there is no effect.

Can you help me out further ?

[echos]

It's hard to know exactly whats going on, simply because I'm unable to analyse whats going on in your code.

So I provided some snipets of code from one of my program that achive the same effect.

<?php
$config['limit'] = 15;

//...

$lastrank = mysql_fetch_assoc(mysql_query('SELECT `Rank` FROM `player_rank` ORDER BY `Rank` DESC LIMIT 1'));
$lastrank = $lastrank['Rank'];

//...

if(@$_GET['position'] != '' and @$_GET['position'] >= 1 and !(@$_GET['position'] > $lastrank))
     {
	 $position = $_GET['position'];
	 }
  else
     {
     $position = 1;
	 }

$rank = 'SELECT * FROM `player_rank` ORDER BY `Rank` ASC LIMIT '. ($position - 1) .','. $config['limit'];

//...

echo "<table width=\"750\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\">\n"
    ."  <tr>\n";
if(!($position <= 1))
     {	
     echo "    <td width=\"48%\"><div align=\"right\"><a href=\"". $_SERVER['PHP_SELF'] ."?position=". ($position - $config['limit']) ."\">&lt; Previous ". $config['limit'] ."</a></div></td>\n";
     }
  else
     {
     echo "    <td width=\"48%\">&nbsp;</td>\n";	 
	 }	 

echo "    <td width=\"4%\"></td>\n";

if(!(($position + $config['limit']) > $lastrank))
     {
	 echo "    <td width=\"48%\"><div align=\"left\"><a href=\"". $_SERVER['PHP_SELF'] ."?position=". ($position + $config['limit']) ."\">Next ". $config['limit'] ." &gt;</a></div></td>\n";
	 }
  else
     {
	 echo "    <td width=\"48%\">&nbsp;</td>\n";
	 }	 	

echo "  </tr>\n"
    ."</table>\n";
?>