Small problem regarding scope in PHP, I can't seem to call the variable $report outside of the while loop. I have tried various things, including return. This doesn't work, the only two functions that work here are if I echo the variable $report inside the loop, or if I print it. Which I do not want to do, although it solves the problem, but I don't want random gibberish on the user's screen.
I have been looking around for the last 15 or so minutes, and I haven't seen any problems quite like this one on here.
Any help would be appreciated.
<?
require "functions2.php";
require "members.php";
$query = "SELECT MAX(DOCid) as prevDOCid from reports";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$prevDOCid = $row[prevDOCid];
$thisDOCid = $prevDOCid+1;
$report = "a"."b".$thisDOCid;
}
echo $report;
?>
$reportis not declared by the time you get to theechostatement, I am guessing PHP never enters thewhileloop in the first place.$row[prevDOCid]. Use quotes:$row['prevDOCid']. It might work, but it's wrong.