[RESOLVED] Setting Value outside Loop

obrienkev

Hi all,

How do I set a value for the link at the bottom without putting it in the loop?

Thanks,

Kevin.

while ($row = mysql_fetch_assoc($result))
{
echo '<tr><td>';
echo $row['course'];
echo '</td><td></td><td>';
echo $row['student'];
echo '</td><td></td><td>';
echo $row['ffnumber'];
echo '</td><td></td><td>';
echo $row['date'];
echo '</td><td></td><td>';
echo $row['completed'];
echo '</td></tr>';
}

echo '</table><br />';

echo '<p><a href="excel2.php?id='.$row['ffnumber'].'">View in Excel Format</a></p>'

justsomeone

each time you execute

$row = mysql_fetch_assoc($result)

the value of $row is repalced. So the code can't "remember" the last value of row. You would need to include something like

$lastrow = $row

at the end of your loop, then change your link to reference $lastrow instead of $row.

obrienkev

No. If I put the link into the while loop the variable $row['ffnumber'] is set.

But in the while loop it is displayed a number of times. Hence why I want it outside of the loop.

But outside of the loop the variable is not given a value.

Any ideas?

justsomeone

You#ve misunderstood me, I think. I know that the variable won't have a value outside of the loop. The final (failed) assignment which breaks you out of the loop will see to that. That's why you need to use the $lastrow.

 while ($row = mysql_fetch_assoc($result))
{
echo '<tr><td>';
echo $row['course'];
echo '</td><td></td><td>';
echo $row['student'];
echo '</td><td></td><td>';
echo $row['ffnumber'];
echo '</td><td></td><td>';
echo $row['date'];
echo '</td><td></td><td>';
echo $row['completed'];
echo '</td></tr>';
$lastrow=$row
}

echo '</table><br />';

echo '<p><a href="excel2.php?id='.$lastrow['ffnumber'].'">View in Excel Format</a></p>'

obrienkev

This worked anyway...

while ($row = mysql_fetch_assoc($result))
{
echo '<tr><td>';
echo $row['course'];
echo '</td><td></td><td>';
echo $row['student'];
echo '</td><td></td><td>';
echo $row['ffnumber'];
echo '</td><td></td><td>';
echo $row['date'];
echo '</td><td></td><td>';
echo $row['completed'];
echo '</td></tr>';
$ffnumber = $row['ffnumber'];
}

echo '</table><br />';

echo '<p><a href="excel2.php?id='.$ffnumber.'">View in Excel Format</a></p>'

justsomeone

yep - two variations on the same idea.