Variable outside of while statement.

[jmassey09]

$sqlQueryFirst=mysql_query("SELECT Hours.WebID, SUM(Hours.Hours), Websites.Cycle, Websites.CycleHours FROM Hours, Websites WHERE Hours.WebID = Websites.WebID AND Websites.Cycle='$_POST[Cycle]' GROUP BY WebID ORDER BY `WebID` DESC LIMIT 1 , 5000");
while($queryFirst=mysql_fetch_array($sqlQueryFirst)){
  $hoursSqlFirst= -$queryFirst['SUM(Hours.Hours)'] + $queryFirst['CycleHours'];
  $webidSqlFirst= $queryFirst['WebID'];
  $First="($hoursSqlFirst,$webidSqlFirst,0,NOW(),'ADJUSTING ENTRY'),";
   }  
$sqlQueryLast=mysql_query("SELECT Hours.WebID, SUM(Hours.Hours), Websites.Cycle, Websites.CycleHours FROM Hours, Websites WHERE Hours.WebID = Websites.WebID AND Websites.Cycle='$_POST[Cycle]' GROUP BY WebID ORDER BY `WebID` DESC LIMIT 0 , 1");
while($queryLast=mysql_fetch_array($sqlQueryLast)){
  $hoursSqlLast= -$queryLast['SUM(Hours.Hours)'] + $queryLast['CycleHours'];
  $webidSqlLast= $queryLast['WebID'];
  $Last="($hoursSqlLast,$webidSqlLast,0,NOW(),'ADJUSTING ENTRY')";
   }
   $All = "INSERT INTO Hours (Hours, WebID, AID, Date, Description) VALUES ". $First ." ". $Last;
   echo $All;
   

 

If i echo the variable "first" inside of its while loop it displays all records. If I echo the variable "first" outside of the while loop it only displays the first record. I thought this script was working last week but obviously I changed something somewhere. Any help is appreciated. Thanks!

[jcbones]

$First is being reset everytime the while loop runs.  To get by this (other than using it in the loop), you would have to make $First an array, then manipulate the data after the while loop finishes.

[jmassey09]

Can you give me an example code? Since I am using php math functions after i fetched the first array, how would I insert the $First records back into an array?

[jcbones]

while($queryFirst=mysql_fetch_array($sqlQueryFirst)){
  $hoursSqlFirst= -$queryFirst['SUM(Hours.Hours)'] + $queryFirst['CycleHours'];
  $webidSqlFirst= $queryFirst['WebID'];
  $First[]="($hoursSqlFirst,$webidSqlFirst,0,NOW(),'ADJUSTING ENTRY'),";
   }  
echo implode(', ',$First);