I have try to use the same $db and to create a new one...
Are you trying to use the $db object inside of another function later in the code? If so you'll need to use $GLOBALS['db'] instead.
Sorry, this is the only thing I can think of with your description Have you tried a simple test program that does nothing more than execute your example below 2 or more times?
...well, wait, now I did have an issue where the constructor of an object was not being executed while mmcache was running. Do you run mmcache or any other code caching mechanism? (phpinfo() would tell you if you're not sure)
Good luck!
On Sep 19, 2005, at 6:26 AM, pcarrie@genasys.com wrote:
Hi! Sorry about the bad english :-[
I try to re-use an object that manage the mysql connections (it is code
from sugarcrm)
$db = new PearDatabase();
$var = "'" . $user_id ."'";
$pregunta = "SELECT user_name FROM users WHERE id = $var";
$resultado = $db->query($pregunta, true, "Error filling in user array: ");
$row = $db->fetchByAssoc($resultado);
$user_name= $row['user_name'];
if i try a new query (can be the same one or an other one), i become "0"
as result and no error message
I have try to use the same $db and to create a new one, i have try to
close the descriptor
Thanks for help
pascal
--PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php