[RESOLVED] database array query

[cbesh2]

I would like to assign my database values in an array format. For example, if my query will return three values, I would like the following:

$fname[1], $fname[2] and $fname[3]

How can this be done?

Below is the code I am starting with:

$query = "SELECT * people WHERE address=$address"; 
$result = mysql_query($query) or die(mysql_error()); 
while($row = mysql_fetch_array($result)){ 
echo $row['fname'];
}

However, I need to be able to select a specific $fname (first, second or third value).

Thank you for your help in advance.

[laserlight]

You would use something along the lines of:

$query = "SELECT * people WHERE address=$address";
$result = mysql_query($query) or die(mysql_error());
$fname = array();
while ($row = mysql_fetch_array($result)) {
    $fname[] = $row['fname'];
}

Note that numerically indexed arrays begin their indices from 0, not 1.

[cbesh2]

Thank you laserlight. That did the trick.
Also, thanks for reminding me that array start with 0, not 1. I would have forgotten.