query($query) ;
while ($db->next_record())
$totordini = $db->f("totordini") ;
$query = "
select
count(O.idordini) as NumOrdini,
C.idclienti as IdClienti,
C.nome as NomeCliente
from
$tclienti C
left join $tordini O on O.idcliente = C.idclienti
group by
C.idclienti,
C.nome
order by
$orderBy
" ;
list($n, $arrVal) = $db->RecuperaDati($query) ;
$arrParGen = array() ;
$arrParGen = RecuperaParametriGenerali($arrParGen, $tparametri) ;
$nome = $arrParGen['NomeAgenzia'] ;
$sede = "Sede operativa: " . $arrParGen['IndirizzoAgenzia'] ;
$datisede = "Telefono: " . $arrParGen['TelefonoAgenzia'] .
" Fax: " . $arrParGen['FaxAgenzia'] .
" -- P.I. " . $arrParGen['PartitaIvaAgenzia'] ;
$emailsede = "Email: " . $arrParGen['MailAgenzia'] ;
?>
<? echo TITLE ?>
 |
|
|
|
| al |
| Nome |
Numero Ordini |
% Ordini |
|
|
|