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 :
le="color: #000000"><?php 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 :
le="color: #000000"><?php $rows = $xoopsDB->fetchArray($result); var_dump($rows);
and get only :
le="color: #000000"><?php 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
