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.

[Erwin]

For any query looking for the user looking at the page, use this:

WHERE userid=$bbuserinfo[userid]

[Jalrock]

Thanks Erwin. That was easy. Now the next question. How do I re-do this query

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

or what do I add to in that would return the results of of the field battle_health?

I have little or new clue when it comes to quering a database but I am trying to learn.

[Erwin]

Where are you using this query? Which PHP file?

You might as well join that query with an existing query in that file, so you save yourself 1 extra query, since there are many queries searching the user table in certain files that you can just add this to.

[NTLDR]

$memhealth[battle_health] is the variable the data is contained in.

[Jalrock]

This is a new php file. I am working on a hack and am stuck on this query.

[Erwin]

Okay, try this.

Make sure at the very top of the PHP file it says this:

PHP Code:

<?php

error_reporting(7);
include('./global.php');

Then try this query:

PHP Code:

      $memhealth=$DB_site->query_first("SELECT battle_health FROM user WHERE userid='$bbuserinfo[userid]'");
      $battle_health=$memhealth[battle_health]; 


And just put $battle_health anywhere in a template that is called from that PHP file. See if that helps.

[Jalrock]

Yea! Erwin it worked. Thanks guys.

[Erwin]

Glad it worked!