getting results into an array...?

[glennn.php]

i have some form fields such as "rent", "elec", "gas", etc...

 

where the values for these fields are stored in a db table with an item_id assigned to each item...

 

using this:

 

while ($row = mysql_fetch_array($result)) {

    echo $row['item_id'].": ".$row['amount'];

}

 

i'm not sure how to get the amounts for item_ids 13, 14, 15... into an array so that i can echo them elsewhere (in their respective textfields), 13 being "rent", 14 being "elec", etc...

 

thanks for the help

 

GN

[Adam]

Do you ONLY want items 13, 14 & 15?

[glennn.php]

no, there are 17 different forms i'd use this on, with a varying number of assigned items. one form has 24 values...

[Adam]

Store the results into an array:

 

$items = array();

while ($row = mysql_fetch_array($result)) {
    $items[$row['item_id']] = $row['amount'];
}

 

That you can reference the array later.

[glennn.php]

beautiful. works like a champ. thanks, mr adam...