doubleJ - 7:10 pm on Jun 27, 2012 (gmt 0)

Ok...
I wasn't figuring out your list(), after all.
Here is what I ended up with and I think it produces the same results.

<?php 
try { 
 $dbh = new PDO("sqlsrv:Server=localhost;Database=Sermons", "", ""); 
 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 
 $sql = "SELECT TOP (100) PERCENT dbo.TblSermon.Day, dbo.TblSermon.Date, dbo.TblSermon.Time, dbo.TblSermon.Speaker, dbo.TblSermon.Series, dbo.TblSermon.Sarasota, dbo.TblSermon.NonFlc, dbo.TblJoinSermonLocation.MeetingName, dbo.TblLocation.Location, dbo.TblLocation.Pastors, dbo.TblLocation.Address, dbo.TblLocation.City, dbo.TblLocation.State, dbo.TblLocation.Zip, dbo.TblLocation.Country, dbo.TblLocation.Phone, dbo.TblLocation.Email, dbo.TblLocation.WebAddress 
  FROM dbo.TblLocation RIGHT OUTER JOIN dbo.TblJoinSermonLocation ON dbo.TblLocation.ID = dbo.TblJoinSermonLocation.Location RIGHT OUTER JOIN dbo.TblSermon ON dbo.TblJoinSermonLocation.Sermon = dbo.TblSermon.ID 
  WHERE (dbo.TblSermon.Date >= { fn NOW() }) 
  ORDER BY dbo.TblSermon.Date, dbo.TblSermon.Time"; 
 $stmt = $dbh->prepare($sql); 
 $stmt->execute();  
 $stmt->setFetchMode(PDO::FETCH_ASSOC); 
 $count = 0; 
 $rows = $currName = null; 
 foreach ($stmt as $row) { 
  if ($row["Location"] == $currName) { 
   $displayName = "&nbsp;"; 
  } else { 
   $displayName = $currName = $row["Location"]; 
  } 
  $rows .= " <tr> <td>" . $displayName . "</td> <td>" . $row["MeetingName"] . "</td> <td>" . $row["Date"] . "</td> </tr> "; 
  $count++; 
 } 
 if ($rows) { 
  echo "<table>" . $rows. "</table>"; 
 } else { 
  echo "<p>No results were found.</p>"; 
 } 
 unset($row); 
 if ($count == 0) { 
  echo "No scheduled events"; 
 } 
 $dbh = null; 
} 
catch(PDOException $e) { 
 echo $e->getMessage(); 
} 
?>