{source 0}
“;
/* inizio schede provinciali ——————————- */
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array(‘s.cognome’, ‘s.nome’,’s.telefono’,’s.email’,’s.image’,’s.telefonoprivato’, ‘s.curriculum’,’s.id’,’s.abitazione_citta’)));
$query->from($db->quoteName(‘#__socio’, ‘s’));
$query->join(‘INNER’, $db->quoteName(‘#__ruolo’, ‘r’) . ‘ ON (‘ . $db->quoteName(‘r.socio_id’) . ‘ = ‘ . $db->quoteName(‘s.id’) . ‘)’);
$query->join(‘INNER’, $db->quoteName(‘#__qualifica’, ‘q’) . ‘ ON (‘ . $db->quoteName(‘r.qualifica_id’) . ‘ = ‘ . $db->quoteName(‘q.id’) . ‘)’);
$query->where(‘ r.settoreoperativo_id = 18 and q.id = 24’);
$db->setQuery($query);
$rows = $db->loadRowList();
for ( $c = 0; $c < count($rows); $c++ ) { $cognome = $rows[$c][0]; $nome = $rows[$c][1]; $telefono = $rows[$c][2]; $email = $rows[$c][3]; $photo = $rows[$c][4]; $telefonoprivato = $rows[$c][5]; $curriculum = $rows[$c][6]; $link = (empty($photo) || is_null($photo)) ? $nophoto : $photo; $socio_id = $rows[$c][7]; $citta = $rows[$c][8]; echo "
“;
/* inizio schede provinciali ——————————- */
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array(‘s.cognome’, ‘s.nome’,’s.telefono’,’s.email’,’s.image’,’s.telefonoprivato’, ‘s.curriculum’,’s.id’,’s.abitazione_citta’)));
$query->from($db->quoteName(‘#__socio’, ‘s’));
$query->join(‘INNER’, $db->quoteName(‘#__ruolo’, ‘r’) . ‘ ON (‘ . $db->quoteName(‘r.socio_id’) . ‘ = ‘ . $db->quoteName(‘s.id’) . ‘)’);
$query->join(‘INNER’, $db->quoteName(‘#__qualifica’, ‘q’) . ‘ ON (‘ . $db->quoteName(‘r.qualifica_id’) . ‘ = ‘ . $db->quoteName(‘q.id’) . ‘)’);
$query->where(‘ r.settoreoperativo_id = 18 and q.id = 24’);
$db->setQuery($query);
$rows = $db->loadRowList();
for ( $c = 0; $c < count($rows); $c++ ) { $cognome = $rows[$c][0]; $nome = $rows[$c][1]; $telefono = $rows[$c][2]; $email = $rows[$c][3]; $photo = $rows[$c][4]; $telefonoprivato = $rows[$c][5]; $curriculum = $rows[$c][6]; $link = (empty($photo) || is_null($photo)) ? $nophoto : $photo; $socio_id = $rows[$c][7]; $citta = $rows[$c][8]; echo "
“;
echo “
echo “
“;
echo “
echo “
“;
echo ““;
echo “
echo ““;
echo “
“;
echo “
“;
echo “
echo “
“.$nome.” “.$cognome.”
“;
echo ““;
if ( $telefonoprivato != ‘1’) {
echo “ ”.$telefono.”“.”  ”;
}
echo ““;
echo ““;
echo “
“.$citta;
echo “
“;
echo “
“;
echo “
“;
echo “
“;
echo ““;
echo “
echo ““;
echo “
“;
echo “
echo “
“;
echo “
echo “
“;
echo “
echo “
“;
echo “
echo “
“;
echo $curriculum;
echo “
echo $curriculum;
echo “
“;
echo “
“;
echo “
“;
echo “
“;
echo “
“;
echo “
“;
echo “
“;
}
echo “
“;
?>
{/source}