Carrying a variable into a new query

I'm posting this Qu again as the last thread was a mess with more than one question going on.

Anyway, I've got WHERE MATCH () AGAINST () working😃 but now I need to add 3 variables from the previous page's form to the query.

I'm building a series of search pages that refine the query... and i assume using the form output from previous pages is the way to go ?!?

How do I reuse variables from a previous page's form ???

This is the SQL from the 2nd results page where i'm trying to include just 1 extra variable (to start with) from the previous page's form.

SELECT * FROM spa
WHERE MATCH Keywords AGAINST ('varRefine') AND spa.Region = '$_GET[$Region2]'
ORDER BY spa.Spa Name

I'm just grasping straws obviously:p How do you pass on variables to be reused on a new page???

thanks in advance for any help,

christL

you could use:

<form action="thirdpage.php">
<input type="hidden" name="my_var" value="<?php echo $my_value?>">
........
</form>

that is if you're using a submit button to go to the third page

or if you follow a link:

<a href="third_page.php?my_var=<?php echo $my_value;?>"> Third page </a>

hope this is what you're looking for

You could also store them in $_SESSION variables.

Thanks for those responses.

Unfortunately I haven't been able to see if they work because of another SQL issue.

This is the QUERY that I'm having trouble with...

SELECT * FROM spa
WHERE MATCH Keywords AGAINST ('varRefine') AND spa.Region = varRegion2
ORDER BY spa.Spa Name

The error I get is:

Unknown column "Australia" in "where clause"

Why is Australia (varRegion2 value) being refered to as a column instead of a value in the Region column ??

thanks again,

christL