Take value from array from database

Question

I have the following code returned by print_r. Return values I need to take the number nine and pass it to a variable.

My question is, how do I take that nine put it into a variable?

Array ( [0] => stdClass Object ( [MAX(userID)] => 9 ) )

Thank you for you reply.

PROTIP: In your SQL, you can do `MAX(userID) AS value`. – gen_Eric Feb 12 '16 at 17:56 — gen_Eric, Feb 12 '16 at 17:56

AbraCadaver · Accepted Answer · 2016-02-12T17:58:46.820

4

You need curly braces with the parentheses in there:

$var = $row[0]->{'MAX(userID)'};

But as Rocket Hazmat states in the comments, just use AS to name it in the query:

SELECT MAX(userID) AS top FROM table

Then it's simpler:

$var = $row[0]->top;

edited Feb 12 '16 at 17:58

answered Feb 12 '16 at 17:56

AbraCadaver

i appreciate, i face the same problem and solve like this way. – Murad Hasan Feb 12 '16 at 17:57
Thank you all, i solved my isue... Thank you very much – user3673405 Feb 12 '16 at 18:05

1 Answers1