simply db result to array question

[knelson]

hello.

i'm sure this is simple, but I falter when it comes to arrays. I need to loop through a result set and assign "md_legacy" to be the key and "subp_display" to be the value:

while(OCIFetch($debut_execute)) 

  {
   	OCIResult($debut_execute, "MD_LEGACY");
    OCIResult($debut_execute, "SUBP_DISPLAY");			
  }

how might I do this in the loop, without overwriting previous array entries?

thanks very much. knelson.

[steved]

Sounds like you want to do something like:

while(OCIFetch($debut_execute)) {
$Array[OCIResult($debut_execute, "MD_LEGACY")] = OCIResult($debut_execute, "SUBP_DISPLAY");

}

as long as your values in the md_legacy column are unique you will not overlay anything. If they are not unique, you won't be able to use that as your key.

[knelson]

thanks. I'll give that a shot. I was also considering a 2-dimensional array approach, but haven't worked out the scheme for that, either.

[knelson]

ok. i've implemented the solution above, but I'm still only returning one set of values (out of 2000), so the array values are being overwritten. any suggestions? thanks again.

				while(OCIFetch($debut_execute))  

{
$debut[OCIResult($debut_execute, "SUBP_DISPLAY")] = OCIResult($debut_execute, "MD_LEGACY"); 
}

$line = each ($debut);
print ("$line[key] is $line[value]\n");

[knelson]

duh. enclose the print function in a loop. everything is working now. thanks again to steved!

knelson