Put table rec to array

[james_cwy]

I am not sure how to put the table records in the array. I am using this.

$sql = "select * from IPaddress";
$getmembers = mysql_query($sql);
while (list($IPAddress) = mysql_fetch_row($getmembers))
{
//put in array
}
say there are 5 records, I want to put all these 5 records in an array starting at [1] to [5] so I do not confuse myself when retrieving

Hope someone can provide some guidance.
Thanks

[bubblenut]

Array's start from 0, it is more logical like that. If you want to avoid confusing yourself you should get comfortable with this.

<?php
$sql = "select * from IPaddress";
$getmembers = mysql_query($sql);
while (list($IPAddress) = mysql_fetch_row($getmembers))
{
  $output[]=$IPAddress;
//put in array
} 

//to loop through the array
$output_c=count($output);
for($i=0;$i<$output_c;$i++) {
  echo(($i+1).": ".$output[$i]."<br />\n");
}
?>

[james_cwy]

Thanks I will check it out.
Appreciate your help