Recursuve function don't work

When doing a recursive function with the mysql class, it does not work, it simply overwrites the results from the earlier function instance, i had to go back to the good old, mysql_query function from php, which works fine.

I HAVE A PROBLEMA: THIS IS MY CODE.

<?php
require_once 'mysql.class.php';
$db = new MySQL(true);

function insertar() {
$db2 = new MySQL(true);
if ( $db2->Error() ) $db2->Kill;
else {
$query = $db2->Query("select * from user");
if ( !$query ) $db2->Kill();
else {
return $db2->RowCount();
}
}
}

if ( insertar() > 0 ) {

$field['nombre'] = MySQL::SQLValue("Roger", MySQL::SQLVALUE_TEXT);
$result = $db->InsertRow('user', $field);
if ( !$result ) $db->Kill();
else echo $db->GetLastInsertID();
} else $db->Kill();
$db->Close();
?>

my table database:

CREATE TABLE `user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`nombre` varchar(45) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8


But, when I make a transaction within the mysql function with the ultimate class, the class did not work.

I HAVE A PROBLEMA: THIS IS MY CODE.

<?php
require_once 'mysql.class.php';
$db = new MySQL(true);

function insertar() {
$db2 = new MySQL(true);
if ( $db2->Error() ) $db2->Kill;
else {
$query = $db2->Query("select * from user");
if ( !$query ) $db2->Kill();
else {
return $db2->RowCount();
}
}
}

if ( insertar() > 0 ) {

$field['nombre'] = MySQL::SQLValue("Roger", MySQL::SQLVALUE_TEXT);
$result = $db->InsertRow('user', $field);
if ( !$result ) $db->Kill();
else echo $db->GetLastInsertID();
} else $db->Kill();
$db->Close();
?>

my table database:

CREATE TABLE `user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`nombre` varchar(45) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8


But, when I make a transaction within the mysql function with the ultimate class, the class did not work.

Cos it needs to be released or closed like this $db->Release(); or $db->Close();

For "mysql_connect", the link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling mysql_close().

refer to: http://php.net/manual/en/function.mysql-connect.php