scripts/blogs.php

<?php
	include ($_SERVER['DOCUMENT_ROOT'] . '/eclipse.org-common/system/smartconnection.class.php');
	
function ganymedeBlogs($count=10) {
	$dbc = new DBConnection();
	$dbh = $dbc->connect();
	$query = "SELECT * from ganymede_spots as GS INNER JOIN ganymede_content as GC on GS.id = GC.id WHERE GC.type = 'Blog' ORDER by GS.id DESC LIMIT $count";
	$result = mysql_query ($query) or die ($query . mysql_error());
	ob_start();
	echo "<ul>";
	while ($rr = mysql_fetch_array($result))
	{
		$author = $rr['name'];
		$title  = $rr['title'];
		$url    = $rr['url'];
		?>
		<li>
			<a href="<?=$url;?>" target="_blank"><? if ($title != "") { echo $title; } else { echo $url; } ?></a> - <?=$author;?>
		</li>
	<? } ?>
	<li class="more">
		<div class="more">
			<a href="mapList.php">Read More</a>
		</div>
	</li>	
	<?
	echo "</ul>";
	$output = ob_get_clean();
	mb_convert_encoding($output, "HTML-ENTITIES", "UTF-8");
	return $output;
} ?>