Need a quick query

[Jalrock]

I am looking to set a variable ($memhealth) from data in the database. Something like this

$memhealth=$DB_site->query_first("SELECT `battle_health` FROM `user` WHERE userid=1");

but to pull from the member viewing the page not form userid 1

the above when put into a template as $memhealth only returns the word "Array" I need it to be the value stored in the database.

Any help appreciated.