Posted by "pcarrie@genasys.com" on 09/19/05 13:26

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

[Back to original message]