$sSQL = "SELECT p.id,p.owner,p.orderID,p.title,p.dateadded,u.email,u.firstname,u.lastname FROM ".PREFIX."listings AS p INNER JOIN ".PREFIX."users AS u ON p.owner=u.id AND display='Y' ";

$result=$db->query($sSQL);
            $numrows = $result->size();
            
            while($rs=$result->fetch())        
            
{
$id=$rs['id'];
                $owner=$rs['owner'];
                $userid=$rs['owner'];
                $title=safeStripSlashes($rs['title']);
                $datelisted=$rs['dateadded'];
                $to=$rs['email'];
                $vars['title']=$title;
                $vars['firstname']=$rs['firstname'];
                $vars['lastname']=$rs['lastname'];
            $class_tpl->assign('location',$userid);
                $content="utenti_report.tpl";
                $class_tpl->assign('location',$userid);
                $msg=$Mailer->sendMail($to, $content,$vars);
                
            }