include ("../common/public.php") ; $q = "select distinct IdFornitori, Nome from (" ; for ($esame = "2002"; $esame <= "2006"; $esame ++) { $tbl_for = "fornitori_$esame" ; if ($esame < "2006" ) $q .= "select IdFornitori, Nome from $tbl_for as F_$esame union " ; else $q .= "select IdFornitori, Nome from $tbl_for as F_$esame) as PP order by Nome" ; } debug (1, $q) ; $query = " select distinct IdFornitori, Nome from ( select IdFornitori, Nome from fornitori_2002 as F1 union select IdFornitori, Nome from fornitori_2003 as F2 union select IdFornitori, Nome from fornitori_2004 as F3 union select IdFornitori, Nome from fornitori_2005 as F4 union select IdFornitori, Nome from fornitori_2006 as F6) as PP order by Nome " ; $db->query($q) ; while ($db->next_record()) { $idfor = $db->f("IdFornitori") ; $arr_for[$idfor] = $db->f("Nome") ; } print_r($arr_for) ; ?>