1
I want to add AgendaX (Pending Events) to my Waiting Content Block. Therefor i used the following:
le="color: #000000"><?php $result = $xoopsDB->query("SELECT COUNT (*) FROM ".$xoopsDB->prefix("agendax_events")." WHERE approved = 0"); if ( $result ) { $block['modules'][8]['adminlink'] = XOOPS_URL."/modules/agendax/admin/index.php"; list($block['modules'][8]['pendingnum']) = $xoopsDB->fetchRow($result); $block['modules'][8]['lang_linkname'] = 'Events'; }
But there is no "Events: xx" in my Block. I think $result is false (i just droped the if part then i saw the Events thing). but why? The SQL String is correct... the table exists
could someone help me plz?
