<?php

// Get a database object
$db = JFactory::getDBO();

$query = "SELECT list.DFirstName, list.DLastName, list.ID, list.eventdate, list.event,
          list.event2, list.place_id, list.eventplace_id, list.Picture, places.place_name as eventplace, places.address as eventplaceaddress, places.city as eventplacecity, 
          places.state as eventplacestate, places.zip as eventplacezip, places.country as eventplacecountry, places_1.place_name as place, 
          places_1.address as placeaddress, places_1.city as placecity, places_1.state as 
          placestate, places_1.zip as placezip, places_1.country as placecountry FROM list INNER JOIN places on 
          list.eventplace_id=places.place_id INNER JOIN places as places_1 on 
          list.place_id=places_1.place_id where list.eventdate >= Now() - 
          Interval 1 Day order by list.eventdate desc, list.ID desc";
$result = mysql_query($query)
	or	die("Couldn't execute query.");
$nrows = mysql_num_rows($result);
for ($i=0;$i<$nrows;$i++)
{

$n = $i +1; //add 1 so that numbers don't start with 0
$row = mysql_fetch_array($result);
extract($row);

?>
<?php print $Picture ?>
obitdisplay?ID=<?php print "$ID" ?><?php print "$DFirstName $DLastName" ?><?php print ":" ?> <?php print date('F j, Y',strtotime($eventdate)); ?>
<?php
    if ($place_id > 0 )
  print $event2;
?> 
<?php

}

?>