loop into an array

[gazalec]

i was just wondering if its possible to make a loop from an SQL database i.e

 

$i=0;
while ($i < $num) {
$code=mysql_result($result,$i,"code");

$i++;
}

 

into an array???

[trq]

<?php
  $i=0;
  while ($i < $num) {
    $code[] = mysql_result($result,$i,"code");
    $i++;
  }
?>

 

$code is now an array.

[Psycho]

OR, also:

<?php
while ($record = mysql_fetch_assoc($result)) {
    $code[] = $record['code'];
}
?>