Question regrding fetch_assoc

[ohad]

Hi all,

 

I have a query that return data into the array $row with values, but $id from the first line of the while stay null. Why?

$con = oci_connect("xxx", "xxx", "xxx");
$query = "SELECT id, name from table_web WHERE record_module='AA' and parent_id='".$parentId."'";
$stid=oci_parse($con, $query);
oci_execute($stid);
while($value = oci_fetch_assoc($stid))
{
	$id = $value['id'];
    $row[$id]['id'] = $value['id'];
    $row[$id]['name'] = $value['name'];
}
return $row;

 

[gw1500se]

oci_fetch_assoc returns an array of all the rows returned by the query. Call it once then put $value in a 'for' loop to process each row.

$rows=oci_fetch_assoc($stid);
foreach ($rows as $row) {
.
.
.
}

 

[ohad]

This still leaves $id from this $id = $value['id'] line null

[requinix]

According to the documentation, oci_fetch_assoc() returns one row of data.

[ohad]

OK problem solved

The issue was 

$id = $value['ID'];

once i changed names of fields to capital letters, all works fine