Data in a while loop with rising numbers?!?

[jmansa]

I want to get data out in rising numbers from an query so I can use it outside the loop...

Here is my query:

$sql="SELECT * FROM ".$prefix."_turn_data WHERE turnid=$matchturn ORDER BY hole_no";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
    
    $par = $row['par'];
    
} 

What I want is to have it come out like this (if 3 records):
$par1, $par2, $par3

I need this later on in the script... Can this be done? Thanks in advance...

[AnthonySterling]

Could this be an option?

<?php
$par = array();
while($row = mysql_fetch_assoc($result))
{
    array_push($par, $row['par']);
}
echo $par[1];
echo $par[2];
echo $par[3];
....
....
....
....
....
....
echo $par[10];
?>

What you're asking is possible, just a bit sloppy IMHO.

[jmansa]

Ahhh Thanks... Did the job ;-)