passing a variable problem

gljones

Hi,

I have a form on one page where someone can enter an area code "310" and then retreive records from a table based on that value.

the results are returned on the 1st page correctly. on the next page that variable is lost somehow.

here's the query:

$query = "SELECT * FROM tnh2 where area = '$area_code'";

now, if i actually enter the are code instead of the variable it works thoughout all pages.

$query = "SELECT * FROM tnh2 where area = '310'";

i can't figure out why it would loose the value of the variable, should it be declared somewhere else on the page? if so, how is this done?

thanks for your help.

aaronvegh

That's right. The variable has to be re-posted as you move page-to-page.

For example, if you have $areacode being passed to the first page, your "Next Page" link would look like this:

<a href="result.php?areacode=<?=$areacode?>">

Cheers,
Aaron.

gljones

thanks again, that worked perfectly.
G.

BigZack

For example, if you have $areacode being passed to the first page, your "Next Page" link would look like this:

You could also put it in a hidden form box like this:

<input type="Hidden" name="areacode" value="<?=$areacode?>">

I try to use this method for passing data between pages instead of in the link... keeps the url clean and stops bookmarking of pages that may not exist on future visits.

gljones

that worked well too. thanks for your help