HELP!! Please answer on 6/11/03, or don't expect response until 6/16/03!

[gengar003]

Hadda put that in the title...
Ok.

how would I pull a single field from the user table, based on a certain userid, and assign it to a variable??

I'm using this:

PHP Code:

$tacemontest = $DB_site->query("SELECT $th_rong_name FROM user WHERE userid='$counter'"); 


But all it returns is Resource#15 Resource#16, etc, etc, etc.

What's wrong?

Oh, $th_rong_name and $counter are variables in the script, and they do do what they should.

[filburt1]

Search and ye shall find.

[gengar003]

.........*explodes*


Right.

EDIT: I can't find it.
EDIT2: Ah.

PHP Code:

$userinfo = $DB_site->query_first("SELECT * FROM user WHERE userid=1"); 


I assume would be changed to:

PHP Code:

$tacemontest = $DB_site->query_first("SELECT $th_rong_name FROM user WHERE userid=$counter"); 


Right?


EDIT3: Wrong.

I'm using

PHP Code:

$tacemontest = $DB_site->query_first("SELECT '$th_rong_name' FROM user WHERE userid='$counter'"); 


And instead of resource#x, y, z, etc, now it just generates the string "Array" endlessly.

[filburt1]

That's because it's an array reference it via $arrayname['keyname'].

[gengar003]

Hm... so, instead of

PHP Code:

echo $tacemontest; 


I'd want

PHP Code:

echo $tacemontest[$th_rong_name]; 


???

[gengar003]

New thing:

Okay, how do I pull the VALUE of that ? I'ts just returning the name...