Problems with passing variables to pages2 + on search results

markbm

I am having an issue whereby I am not able to get the variables back on pages 2 + for
a search results page that I have built. Basically, I have a search form page, which POSTs the
variables that are used to build my mySQL WHERE statement. The below page (which is the
search results page) works perfectly on page 1...in all cases. However, when clicking a link to go to
successive pages and/or PREV and/or NEXT...the variables are not passed and my sql statement changes
from, for example,

query_where= "where HEAT_SQ_FT >= 0 AND HEAT_SQ_FT <= 9999 AND HPG_PLAN_ID like '%-1%' AND ACTIVE=1 order
by HEAT_SQ_FT DESC"

query_where= "where HEAT_SQ_FT >= 0 AND HEAT_SQ_FT <= 9999 AND ACTIVE=1 order by HEAT_SQ_FT DESC"

In essence, the "passed" variables are not retained for inclusion in the select on successive pages.

It does seem to work, on successive pages, when I only pass the HEAT_SQ_FT TO and FROM information, but
not if I add any other variables...

Any ideas would be greatly appreciated. Thank you for your help.

Mark

kevinsequeira

just pass the posted variables in the next/prev link like so

echo "<A HREF=\"$PHP_SELF?from=$from&to=$to&offset=$newoff&where=$safewhere&HPG_PLAN_ID=$HPG_PLAN_ID\">

and so on

reg
kevin

markbm

Kevin,

Thanks so much for the note. I have already tried that particular method to no avail. Basically, the variable names show up in the url...but all values are blank. Here is the updated piece of code:

==============================

 //Next / Previous links

function pagenav() {
global $limit,$offset,$numpage,$where, $from, $to;
if ($where) {

    $safewhere=urlencode($where);

    if ($gonethru == 1){
    	$safewhere=$getvars;

   	};

    //$safewhere=$query_where;
}

echo "<center>";
if ($offset>=$limit) {
$newoff=$offset-$limit;

        echo "<A HREF=\"$PHP_SELF?from=$from&to=$to&offset=$newoff&where=$safewhere&hpg_plan_search=$hpg_plan_search&bed_search=$bed_search&bedto_search=$bedto_search&bathfrom_search=$bathfrom_search&bathto_search=$bathto_search&levels_where=$levels_where\">
        <font size=3 face=Verdana, Arial, Helvetica, sans-serif color=blue>PREV</font></A>";
           // </TD>";
    }; 
     echo "&nbsp;";


    for ($i=1;$i<=$numpage;$i++) {
        if ((($i-1)*$limit)==$offset) {
            print "$i ";
        } else {
            $newoff=($i-1)*$limit;

            echo "<A HREF=\"$PHP_SELF?from=$from&to=$to&offset=$newoff&where=$safewhere&hpg_plan_search=$hpg_plan_search&bed_search=$bed_search&bedto_search=$bedto_search&bathfrom_search=$bathfrom_search&bathto_search=$bathto_search&levels_where=$levels_where\">
            <font size=3 face=Verdana, Arial, Helvetica, sans-serif color=blue>$i</font></A> ";
        }
    }
     echo "&nbsp;";

    if ($offset!=$limit*($numpage-1)) {
        $newoff=$offset+$limit;
        echo ("<A HREF=\"$PHP_SELF?from=$from&to=$to&offset=$newoff&where=$safewhere&hpg_plan_search=$hpg_plan_search&bed_search=$bed_search&bedto_search=$bedto_search&bathfrom_search=$bathfrom_search&bathto_search=$bathto_search&levels_where=$levels_where\">");
        echo ("<font size=3 face=Verdana, Arial, Helvetica, sans-serif color=blue> NEXT</font></A><br>");
        //printf("<a href=http://www.houseplangallery.com/index_files/plan_sizes.php><img src=images/backtosearch.gif border=0></a><br>");
        //echo (" <br>");
    };
     printf("<a href=http://www.websitename.com/index_files/plan_sizes.php><FONT COLOR=BLUE>[BACK TO SEARCH]</FONT></a><br><br></td>");

echo "</center>";

} // END FUNCTION

==============================

Is there anywhere else, that I'm maybe missing not adding the variables to?

Thanks again for your help.

Mark

kevinsequeira

is the page available on an external url or is it on your local machine ?? the reason i ask is so that i can take a look at the search directly.

reg
kevin

markbm

Passing the initial variables to the second page, along with adding them to the globals definition worked on the subsequent pages!!
Thank you, each of you, for your helpful assistance. I really appreciate it.

Sometimes I get so entrenched in the details of an issue, that the more obvious solutions are harder to recognize. Thank you again for your help.

Mark