[RESOLVED] Help with Variables, Global issue?

chadman

Newbie here. Please xcuse my igonrance.

I am attempting to modify a query SELECT statement based on checkboxes being checked or not in a seperate URL. The checkboxes (one for each field) will determine which fields will be shown in the query. Here is part of 'checkbox.php'.

<form name=checker method=post action="createquery.php">
<input type=checkbox name=pname checked> Player Name<br>
<input type=checkbox name=team checked> Team<br>
<input type=checkbox name=owner checked> Owner<br>
<p><input type=submit value=Update>
</form>

At 'createquery.php' I have a list of IF(ISSET())s for each checkbox and then create a variable to drop into my query called $batquery, like so.

if (isset($pname)) {$showplay="PlayerName";} else {$showplay="";}
if (isset($team)) {$showteam="Team";} else {$showteam="";}
if (isset($owner)) {$showowner="Owner";} else {$showowner="";}

$batquery="$showplay,$showteam,$showowner";

Now I want to return to ANOTHER .php file (call it query.php) and run my query using $batquery from createquery.php in the statement. My question is, how do I use this variable I've created in query.php? I've tried using an 'include' statement in query.php, and referencing 'createquery.php', but that always give me the two commas, with no values for $showplay, $showteam, or $showowner.

Is this an issue of declaring a variable globally?

if there's a better way to accomplish this I'm open to anything. Thanks for any help.

rincewind456

I would suggest using sessions, a

session_start()

at the start of each page and then make your

$batquery ="$showplay,$showteam,$showowner";

into

$_SESSION['batquery'] ="$showplay,$showteam,$showowner";

chadman

Thanks, looks like SESSIONs is the right way to go. I am still having a probelm at the query.php level. When I call $_SESSION['batquery'] there, it doesn't seem to know what that variable is, and crashes. I have added 'start_session();' at the top of query.php.

I imagine that I am not properly passing the $_SESSION vars to the query.php. Is there a correct way to forward to query.php from createquery.php without closing a session. Perhaps that is my problem. Right now I am just clicking on an <a href=> link.

Thanks again.

chadman

I have confirmed that $_SESSION['batquery'] is passed to query.php properly. What I didnt say is that in Query.php, I have a form which sets more variables, and whose action is another URL , results.php, which performs the actual query and shows the results.

I CANNOT get results.php to recognize $_SESSION['batquery']. And I have added 'start_session();' to all of these files.

Any ideas?

chadman

It is being passed to results.php. I think that Query just doesnt like the string that $_SESSION['batquery'] is equal to.

Thanks anyway.