oci query in PHP returning array not working

Question

Using print_r bellow simply prints Array ().

Why is this not working?

$conn = oci_connect("wwbms_admin", "wwbms_admin", "PDBQA");

$sql = "SELECT COUNTRY_ID, DESCRIPTION FROM COUNTRY";
$query_country = oci_parse($conn, $sql);

$list = array();

$result = oci_execute($query_country, OCI_DEFAULT);

while(($row = oci_fetch_assoc($query_country))) {
$items[$row['DESCRIPTION']] = $row['DESCRIPTION'];
}

print_r($list);

oci_close($conn);

Any help would be great, thanks.

I don't see $list ever being assigned values. Is this a typo or is something missing from above? — sbatson5
– sbatson5, Commented Apr 10, 2013 at 20:17

Matt · Accepted Answer · 2013-04-10 20:16:25Z

1

You set $list to an empty array(), then you run print_r on it. You never set it again. You're getting predictable results.

Maybe you meant to print_r($items);?

answered Apr 10, 2013 at 20:16

Matt

5,4381 gold badge34 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1214840 Over a year ago

I apologize, I am an idiot of course yes, Thank you for making me see the obvious :)

Collectives™ on Stack Overflow

oci query in PHP returning array not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related