While Not Working Correctly

[The Little Guy]

For some reason the last while loop isn't working

<?php
while($row2 = mysql_fetch_array($sql)){
$file_amount += $row2['size'];
}
$file_space = round($file_amount/1024,2);
if($file_space <= 1024){
echo "<b>$file_space"."KB</b>";
}elseif($file_space >= 1024 && $file_space < 1073741824){
$file_space = round($file_space/1024,2);
echo "<b>$file_space"."MB</b>";
}elseif($file_space >= 1073741824){
$file_space = round($file_space/1073741824,2);
echo "<b>$file_space"."GB</b>";
}


while($row = mysql_fetch_array($sql)){
echo '<p>'.$row['file_name'].'</p>';
}
?>

 

but... if i remove everything except for the last while loop, then it works.

 

Anyone know why?

 

There are no error messages at any point and time.

[trq]

Because you have already looped through all the results in your first loop. You will need to use mysql_data_seek to move the pointer back to the start.

[ph2007]

It doesn't look as though the contents of your second while loop require any of the previous code to already be completed.  Why don't you put the echo string in the first while loop?

[The Little Guy]

It doesn't look as though the contents of your second while loop require any of the previous code to already be completed.  Why don't you put the echo string in the first while loop?

Then the content will echo out incorrectly.

[The Little Guy]

Because you have already looped through all the results in your first loop. You will need to use mysql_data_seek to move the pointer back to the start.

But the two row variables are different, it shouldn't matter. Shouldn't it?

[lee20]

Try building an array while looping the results, and then loop the array in your second loop like so:

 

<?php
$rows = array();
while($row2 = mysql_fetch_array($sql)){
        $rows[] = $row2;
$file_amount += $row2['size'];
}

$file_space = round($file_amount/1024,2);
if($file_space <= 1024){
echo "<b>$file_space"."KB</b>";
}elseif($file_space >= 1024 && $file_space < 1073741824){
$file_space = round($file_space/1024,2);
echo "<b>$file_space"."MB</b>";
}elseif($file_space >= 1073741824){
$file_space = round($file_space/1073741824,2);
echo "<b>$file_space"."GB</b>";
}


foreach ($rows AS $row) {
echo '<p>'.$row['file_name'].'</p>';
}
?>

 

Note: You may want to use a for loop instead of a foreach loop because if there are no results you will get an error in this case.

 

Cheers