Multiple queries on one mysqli object?

[Cronos]

I'm still new to MySQL/PHP. The book I've ordered hasen't arrived yet, and I am eager to learn. :P

Now, here's the problem:

Is it possible to have multilpe queries on one mysqli object?

I found some code, and tried amending it, but it doesn't work.
I get Fatal error: Call to a member function query() on a non-object in /home/.mohave/tetest/<mysite>/ex/table2b.php on line 35
which leads me to believe that the "object" somehow closes connection with the db after one query.
Also, with my setup I cannot use $result.close() to "release" the connection.

$connect = new mysqli("....")

$query = "SELECT
      * ..."

$result = $connect->query($query)

function f1() {

     $query_a = "SELECT.."
     $results_a =  $connect->query($query_a)   <-- line 35
        ..do something...
}

function f2() {

     $query_b = "SELECT.."
     $results_b =  $connect->query($query_b)
        ..do something...
}

while($row = $result->fetch_array(MYSQLI_ASSOC))
{
    f1(some parameter from $row)
    f2(another parameter from $row)
    ...do something more...
}

[codeexploiter]

Make sure that you are connected to the database properly before executing any queries. Here is a step-by-step tutorial about the PHP-MySql interaction

http://www.php-mysql-tutorial.com/

[Cronos]

I'm quite sure I am connected b/c the first query doesn't yield any errors, and I'm also able to get a quantitative response (I'm able to get num_rows).

[Cronos]

I've partly figured it out.
It's a question of scope.
I supposedly need to globally declare variables within functions.

http://www.phpbuilder.com/board/show...php?t=10308946

Well. I'm still learning.