PHP Getting valuse of Arrays that are inside Objects

Question

I'm running a query that looks like this:

 $results = $DB2->query("SELECT COUNT(*) FROM auth_user as count WHERE email='" . $DB2->escape_str($email) . "';");

It's returning an object that looks like this:

DB_Cache Object
(
[result] => Array
    (
        [0] => Array
            (
                [COUNT(*)] => 0
            )

    )

[row] => Array
    (
        [COUNT(*)] => 0 // I WANT YOU!
    )

[num_rows] => 1
[q_count] => 1
[fields] => Array
    (
    )

)

I am trying to access the [count] array value using this:

$results->row['count'];

It's not returning anything. Any ideas what I'm doing wrong?

There is no count array value, though there might be a COUNT(*) one. — salathe
– salathe, Commented Jun 17, 2010 at 18:16

Kerry Jones · Accepted Answer · 2010-06-17 18:16:53Z

3

Change your SQL statement from COUNT(*) to COUNT(*) AS count

answered Jun 17, 2010 at 18:16

Kerry Jones

21.8k12 gold badges67 silver badges89 bronze badges

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

1 Comment

Philip Zaengle Over a year ago

Thanks a ton! Totally missed that.

Simon · Accepted Answer · 2010-06-17 18:16:07Z

1

Try this:

$results->row["COUNT(*)"]

The value between [] indicates the key of the array. You have to use exactly that key in order to access the array's value.

answered Jun 17, 2010 at 18:16

Simon

9,4054 gold badges40 silver badges56 bronze badges

Collectives™ on Stack Overflow

PHP Getting valuse of Arrays that are inside Objects

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related