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.

AbraCadaver · Accepted Answer · 2016-02-12 17:58:46Z

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;

answered Feb 12, 2016 at 17:56

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

2 Comments

i appreciate, i face the same problem and solve like this way.

Thank you all, i solved my isue... Thank you very much