$connection = pg_connect ("host=$host dbname=$db user=$user password=$pass");
if (!$connection)
{
die("Could not open connection to database server");
}

$query = "SELECT entry_title, entry_id, entry_class, entry_authored_on, entry_basename FROM mt_entry ORDER BY entry_authored_on";

$result = pg_query($connection, $query) or die("Error in query: $query. " . pg_last_error($connection));
// get the number of rows in the resultset
$rows = pg_num_rows($result);

// if records present
if ($rows >  0 )
{
// iterate through resultset
for ($i= 0 ; $i<$rows; $i++)
{
$row = pg_fetch_row($result, $i);
?>
<li><font size="-1"><b><? echo $row[ 0 ]; ?></b></font>
<br>
<font size="-1"><? echo $row[ 1 ]; ?><br>/<? echo $row[ 2 ]; ?>/<? echo $row[ 3 ]; ?>/<? echo $row[ 4 ]; ?></font>
<p>
<?
}
}
// if no records present
else
{
?>
<font size="-1">No data available.</font>
<?
}

pg_close($connection);

$query = "SELECT entry_title, entry_text, entry_authored_on, entry_basename, mt_placement.placement_category_id FROM mt_entry, mt_placement WHERE entry_id = mt_placement.placement_entry_id AND entry_class = 'entry' ORDER BY entry_authored_on DESC";

$query = "SELECT e.entry_title, e.entry_text, e.entry_authored_on, e.entry_basename, e.entry_id, p.placement_entry_id, p.placement_category_id, c.category_id, c.category_basename FROM mt_entry e, mt_placement p, mt_category c WHERE  (e.entry_id = p.placement_entry_id) and (p.placement_category_id = c.category_id) and e.entry_class = 'entry' ORDER BY e.entry_authored_on DESC";

$query = "SELECT e.entry_title, e.entry_text, e.entry_authored_on, e.entry_basename, e.entry_id, p.placement_entry_id, p.placement_category_id, c.category_id, c.category_basename FROM mt_entry e, mt_placement p, mt_category c WHERE  (e.entry_id = p.placement_entry_id) and (p.placement_category_id = c.category_id) and e.entry_class = 'entry' ORDER BY e.entry_authored_on DESC LIMIT 10";