I have a little snippet I have used to connect to a separate non-modx database to pull events.
Can someone help me get this working in Revo?
It is messy and not very good... but it works.
<?php
$result = $modx->db->select('event_id,title,sub_title,resort,start_date,end_date,website,resort_website,image','fred88_db.events','start_date >= NOW()','start_date ASC');
if( $modx->db->getRecordCount( $result ) >= 1 )
{
while( $row = $modx->db->getRow( $result ) )
{
echo "<div style='height:150px;padding-bottom:20px;clear:both;'>";
echo "<img src='http://events.webiste.com/imgs/thumbs/";
echo $row['image'];
echo "'width='120' align='left' style='margin-right:10px;' class='speakerthumb'>";
echo '<h1>';
echo $row['title'];
echo '</h1>';
echo $row['sub_title'];
echo '<br/>';
echo $row['start_date'];
echo '<br/>';
echo '<a href=' . $row['website'] . '>'. $row['title'] .'</a>';
echo '<br/>';
echo '<a href=' . $row['resort_website'] . '>'. $row['resort'] .'</a>';
echo '</div>';
}
}
?>
