blob: d3ed3e6d60d201a9cb84df7c8188f8080b8107af [file] [log] [blame]
$documentRoot = $_SERVER['DOCUMENT_ROOT'];
require_once($documentRoot . "/");
$liveConnection = new DBConnectionLIVE();
<table class="webinars" cellspacing=0 cellpadding=0>
<tr class="header">
<td width="70%">Title</td>
<td width="15%">Format</td>
$sql = "SELECT cn.nid, n.title, nn.title as format, ncr.field_abstract_value as abstract from category_node as cn
INNER JOIN node as n on n.nid = cn.nid
INNER JOIN category_node as cat_node on cat_node.nid = cn.nid
INNER JOIN node as nn on nn.nid = cat_node.cid
INNER JOIN node_content_resource as ncr on ncr.nid = cn.nid
WHERE cn.cid = 542 AND cat_node.cid IN (18, 19, 20) AND n.status = 1 ORDER by n.created desc";
$result = mysql_query($sql);
while ($rr = mysql_fetch_array($result))
$title = $rr['title'];
$format = $rr['format'];
$id = $rr['nid'];
$abstract = $rr['abstract'];
$abstract = str_replace('<img height="10" src="/files/images/adobeconnect.jpg"/>', '', $abstract);
$url = ''. $id;
?> <tr>
<div id="<?=$id;?>" class="invisible">
<a class="norgie" onclick="t('<?=$id;?>', '<?=$id;?>a');" name='<?=$name?>'></a>
<a href="<?=$url;?>"><?=$title;?></a>
<td colspan="2" class="hidden">
<div class="invisible" id="<?=$id;?>a">
<div class="item_contents"><?=$abstract;?></div>