[RESOLVED] Create Multidimensional Array from query

[j_70]

I need to create a multidimensional array from a database query. This is an Oracle query and I do not believe the OCI interface has a function to create a two-dimensional array. I imagine it is something like this:

while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {

 <do something to create two dimensional array>


 }

TIA.

[laserlight]

It really depends on what is this multi-dimensional array in the first place since we cannot advise you how to randomly create multi-dimensional arrays from a query. I suspect you are looking to write:

$array = array();
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
    $array[] = $row;
}

[j_70]

Thanks for the reply. $row is an array returned by OCI. I believe you solution will work. Thanks.

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved (if it is) using the thread tools.