<?php

function toto($id)
{
   $query =  "SELECT COUNT( * ) "
     . "FROM #__hp_properties AS p "
     . "LEFT JOIN #__hp_prop_types AS t ON t.id = p.type "
     . "WHERE t.id = '".$id."'";
   $database->setQuery( $query );
   return $database->loadResult();
}

?>