newbie needs help with form

[bloomoon]

i run an sql on my interbase table and my $result looks like this:

    --------------------------------------------------------------------------
    |    CLIENT_ID   |  NAME   |    APP_ID   |    VERSION_NO    |
    --------------------------------------------------------------------------
    |          1            |    ADA   |    1            |        4.1.0.1          |
    |          1            |    BBT    |    2            |        4.1.0.2          |
    |          1            |    SHU   |    3            |        4.1.0.3          |  
    |          1            |    PIN    |    4            |        4.1.0.4          |
    --------------------------------------------------------------------------

my problem is trying to display this information within 5 textfields of a HTML form. i want:

textfield 1 to display CLIENT_NAME from row 1
textfield 2 to display VERSION NO from row 1 again
textfield 3 to display VERSION NO from row 2
textfield 4 to display VERSION NO from row 3
textfield 5 to display VERSION NO from row 4

1. i tried putting the following code into the value tag of textfield 1:

<php
while ($row= ibase_fetch_row ($result)){
echo ibase_result($result, 0, "CLIENT_NAME")
?>

i thought this code would allow me to display the client name value of a specific row. i could then repeat a variation of this code in each FORM value tag. but it doesnt work and is not listed as an interbase function like it is with MySQL.

I think this is a basic problem but its got me stumped. Can someone please help me. Ive been trying to solve this for ages and am very frustrated.

[barand]

Read your data and store in array. you can the access any row as you want

[bloomoon]

how do i do this?

[barand]

$row=0;
while (list($client,$name,$appid,$version) = ibase_fetch_row($result)) {
$array[$row]['client'] = $client;
$array[$row]['name'] = $name;
$array[$row]['appid'] = $appid;
$array[$row]['version'] = $version;
$row++;
}

to access client from first row

$client = array[0]['client'];

to access version from row 3

$version = array[2]['version];

Note rows number from 0, not 1.

hth

[bloomoon]

THANKS!!!