Passing variables to included pages

mrgrammar

I have page1 that uses that 'includes' page2. Page2 uses an 'include' for page3. Page3 needs a variable that is set on page1 before page2 is included. Pages 1-3 are all located within different subdirectories of the web site.

// PAGE1
// http://www.domain.com/page1.php
  $g=1;
  $w=500;
  include "page2.php";

// PAGE2
// http://www.domain.com/sub1/sub2/sub3a/page2.php
  // stuff here prior to include
  include "../../../page2.php";
  // stuff here after include

// PAGE3
// http://www.domain.com/sub1/sub2/sub3b/page3.php
  $query = "SELECT * FROM table WHERE rotations_id = ".$g;
  echo $query."<br>";
  mysql_db_query($db, $query) or die(mysql_error());

The error it gives me is:

SELECT * FROM table WHERE rotations_id =
You have an error in your SQL syntax near '' at line 1

which is because the variable $g did not get passed.

So here's my question. Why isn't the variable passing to the query and how do I get it to do so?

leatherback

Is the query located within a function somehow?

Because it should not be a problem. And since when you load page1, you get the error from page3, the includes work just fine.

mrgrammar

Actually, there was one more part. Page3 included a file from the top level directory. (I know this all sounds convoluted, but I have 11 sites that all draw from the same set of files.)

So:

PAGE1 http://www.domain.com/page1.php 

includes PAGE2 http://www.domain.com/sub1/sub2/sub3a/page2.php
which controls the layout of the page
and which sets a variable -- $g=1

and includes PAGE3 http://www.domain.com/sub1/sub2/sub3b/page3.php
which displays an ad

and includes PAGE4 http://www.domain.com/page4.php
which has all the code to select the ad out of the ad rotation

  $query = "SELECT * FROM table WHERE rotations_id = ".$g; 
  echo $query."<br>"; 
  mysql_db_query($db, $query) or die(mysql_error());

All the includes are working properly. After some testing (between the last post and this one), the variable set on page2 works on page3. However, when page4 is included, the variable is not recognized.

I solved the problem by moving page4 into the same subdirectory as page3. I'm just curious now why a variable -- $g=1 -- on page2 is recognized on include page3 but not on include page4. It must have something to do with the files being in different directories since all the includes work and the variable is recognized if page3 and page4 are in the same directory.