[SOLVED] Question

[Minase]

i'm a little stuck at this :|

 

normally i would use $user->Gold to return the gold a user have

but if i use SUM then something like this occurs

 

stdClass Object ( [sUM(Gold)] => 227 )

 

and it should be just

 

stdClass Object ( [Gold] => 227 )

 

in this way $user->Gold is not accessible.

 

any ideas?

ty

[Mark Baker]

In your sql query, assign a synonym

SELECT userid, 
       SUM(gold) as gold
  FROM table
GROUP BY userid

[Minase]

thanks