1
Hi
I got a problem to get a proper answer to a mysql query, even when I follow the "How to build your own XOOPS module" -> "The queries" recomendations :
global $xoopsDB;
$table = $xoopsDB->prefix('config');
$sql = "SELECT conf_value FROM x3ae_config WHERE conf_title
IN('_MI_PHPBB3_ROOT_PATH', '_MI_PHPBB3_DB_HOST', '_MI_PHPBB3_DATABASE',
'_MI_PHPBB3_DB_USER', '_MI_PHPBB3_DB_PASS', '_MI_PHPBB3_USERS_TABLE');";
$result = $xoopsDB->queryF($sql);
list($PHPBB3_ROOT_PATH, $PHPBB3_DB_HOST,
$PHPBB3_DATABASE, $PHPBB3_DB_USER, $PHPBB3_DB_PASS, $PHPBB3_USERS_TABLE)
= $xoopsDB->fetchRow($result);
echo $PHPBB3_ROOT_PATH, $PHPBB3_DB_HOST, $PHPBB3_DATABASE, $PHPBB3_DB_USER,
$PHPBB3_DB_PASS, $PHPBB3_USERS_TABLE;
All I can get as answer is the first item ($PHPBB3_ROOT_PATH) when the query
answers fine in the mysql shell ?
I tried also :
$rows = $xoopsDB->fetchArray($result);
var_dump($rows);
and get only :
array(1) { ["conf_value"]=> string(8) "/phpbb3/" }
I guess that I miss something but what ?
Any idea ?
Thank you
"A tree is made of non-tree elements" Thich Nhat Hanh
