[PHP-DB] Re: Trying to make site map

2010-01-03 Thread Brian Smither
It breaks apart when I try to go on the third level. On the second iteration of $secpageArray, it fetches Row4 from the database. Because there is no Page_Above that equals 4 (that is, no child of Page 4 in your map), the level 3 query might be coming back as False (no records returned), which

[PHP-DB] Re: Trying to make site map

2010-01-03 Thread Brian Smither
It breaks apart when I try to go on the third level. =Sorry, my email client didn't word-wrap.== On the second iteration of $secpageArray, it fetches Row4 from the database. Because there is no Page_Above that equals 4 (that is, no child of Page 4 in your map), the level 3 query might be coming

[PHP-DB] Re: jpgraph and mysql passing array

2011-03-26 Thread Brian Smither
Would you try an experiment? In this line: $sql = (SELECT * FROM evdobanding WHERE Market like '%$term' and Cell_Sect = '$term2' and Date = '$term3' ORDER BY distance asc); Change to: $sql = SELECT * FROM evdobanding WHERE Market like '%.$term.' and Cell_Sect = '.$term2.' and Date = '.$term3.'