$con = Propel::getConnection(); 
$sql = 'Select blah blah';

$stmt = $con->prepareStatement($sql); 
$rs = $stmt->executeQuery(ResultSet::FETCHMODE_ASSOC);
$this->rs = $rs;

foreach($rs as $row) {
 foreach($row as $item) {
  echo $item;
 }
}

<table name="vwContacts" idMethod="native" phpName="vwContact">
 <column name="ContactID" type="integer" required="true" primaryKey="true" autoIncrement="true" />
 <column name="ContactName" type="varchar" size="255" />
 <column name="ContactTel" type="varchar" size="50" />
</table>

$c = new Criteria();
$this->vwList = vwListPeer::doSelect($c);

$c = new Criteria();
$pager = new sfPropelPager('vwList', 10);
$pager->setCriteria($c);
$pager->setPage($this->getRequestParameter('page', 1));
$pager->init();
return $pager;

+9886 	Creole	prepareStatement(): SELECT COUNT(vwList.ID) FROM vwList

+9499 	PHPView	execute view for template "listSuccess.php"
+8863 	PHPView	decorate content with "sf_app_dir\templates/layout.php"

<?
	$connection = mssql_connect( "127.0.0.1",[user],"[pass]")
	or die ( "Sorry - unable to connect to MS SQL" );
	echo( "Congratulations - you are connected to MS SQL" );
	$db = mssql_select_db('[db]',$connection)
	or die ("Sorry database not found");
	$result = mssql_query("select * from vwList");
?>
	<table>
<?
	for ($i = 0; $i < mssql_num_rows($result); ++$i) {
		$row = mssql_fetch_row($result);
?>
	<tr>
<?
	foreach ($row as $field)
	{
		echo '<td>'.$field.'</td>';
	}
?>
	</tr>
<?
	}
?>
	</tbody>
	</table>

<?
	$odbc['dsn'] = '[dsn]';
	$odbc['user'] = '[user]';
	$odbc['password'] = '[pass]';

	$conn = odbc_connect($odbc['dsn'],$odbc['user'],$odbc['password'])
		or exit("<h2>Cannot connect to DSN " . $odbc['dsn'] . "</h2>");
	if($conn) { echo "<h2>ODBC Connection Successful</h2>"; }
	$odbcquery = "SELECT * from vwList";
	$odbcexec = odbc_do($conn, $odbcquery);
	odbc_result_all($odbcexec, "");
	odbc_close($conn); 
?>