1
ok this is my situation
im helping a friend to create a website for a big company with big staff
i have create a simple staff directory module ..just to display name position department email
and contact number of staff
i also use publisher module by trabis to display information about each of the department
in the company like finances, ict etc
what i would like to do is to include my directory in the publisher page
what i did was to create a php query page
like
Quote:
if ($filename=='xxx333.com/publisher.item.4/finances.html')
{
global $xoopsDB;
$result = mysql_query("SELECT * FROM ".$xoopsDB->prefix("staf_directory")." WHERE department='Finances' ORDER BY seniority");
---
----
}
and put it in a php custom block
include statement
and use the defacer method...
https://xoops.org/modules/newbb/viewtopic.php?post_id=327670#forumpost327670i put this in publisher
<{$xoops_block_11.content}>
but it is not working...i see the smart variable and not the block content
am i doing this wrong...is there any easy way to do this ? please advise
i am a noob
I Love Xoops