Pear DB simple query

[Silent1]

i'm busy messing around with the pear package db (mysqli) and was wondering if theres a simple way to do simple select queries. Like say grab a username based on a user id.

$TestSQL = "SELECT * FROM `users` WHERE U_ID='0'";
$Results = $dbh->getAssoc($TestSQL);
print_r($Results);

which prints this out,
Array ( [0] => Array ( [0] => username [1] => password ) )

Is there just a simple method that instead of the results in an array its a variable. Thanks in advance.

[Weedpacket]

$Results is a variable that contains an array. So what do you mean by having the "results in a variable"?