hallo,
wie verwende ich richtig ein elseif Konstrukt?
wenn ich folgenden Code ausführe, erhalte ich einen parse error:
Danke.
HM
wie verwende ich richtig ein elseif Konstrukt?
wenn ich folgenden Code ausführe, erhalte ich einen parse error:
PHP-Code:
if ($qry == $TT_totali) {
$sql = "SELECT elaboratore, count(*) as TOTALE from trouble2 where apert
ura >='" . $sub_data_b . "' and apertura <='" . $sub_data_e . "' group by elabor
atore order by TOTALE desc";
} elseif ($qry == $TT_helpdesk) {
$sql = "select elaboratore, categoria, count(elaboratore) as TOT from tr
ouble2 where apertura >='" . $sub_data_b . "' and apertura <='" . $sub_data_e .
"' and categoria='HELP DESK' group by elaboratore, categoria order by TOT desc";
} elseif ($qry == $TT_callcenter) {
$sql = "select elaboratore, categoria, count(elaboratore) as TOT from tr
ouble2 where apertura >='" . $sub_data_b . "' and apertura <='" . $sub_data_e .
"' and categoria='CALL CENTER' group by elaboratore, categoria order by TOT desc
";
} else ($qry == $TT_rifiuti) {
$sql = "SELECT elaboratore, count(esito) from details2 where esito='Rifi
utata' and apertura >='" . $sub_data_b "' and apertura <='" . $sub_data_e . "' a
nd elaboratore in (xxxxxxxxxxxxx) group by elaboratore order by count d
esc";
}
HM
Kommentar