passing of variables

[phutie]

Hi,

I declared my variable as global and used it to hold a query result but the variable is not passing its value to another php page where I need it again for another query something like this:

1st php page:
global $comp

$result = "Select Company from dbtable where Name = ABC";
$comp = $mysql_query($result);


2nd php page:

$query = "Select Branch from dbtable2 where Company = '$comp'";

pls help

[cpradio]

okay to do that you will need to pass $comp in the link that goes to php page 2.

<a href="phpPage2.php?comp=<?php echo "$comp"; ?>">Go to Page 2</a>

Then to grab that variable you would use the following in PHP Page 2:

$comp = $_GET['comp'];
$query = "Select Branch from dbtable2 where Company = $comp"; // no single quotes 

-Matt

[phutie]

thanks, I'll give it a try!

[filburt1]

...and on a similar note: if you pass the variable via a POST method of a form, use $_POST['varname'].