1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
$j=1;
if ($_SESSION['sessType']=='J')
{$qYear = "SELECT extract(YEAR from afdatj1) as year from affaire where afsiret<>'' and (affaire.afjuge='".$_SESSION['sessCode']."') group by year";}
if ($_SESSION['sessType']=='A')
{$qYear = "SELECT extract(YEAR from afdatj1) as year from affaire where afsiret<>'' and (affaire.afjuge='".$Juge."') group by year";}
$resultyear = mysql_query($qYear)or die("laaaalaaalaaalaaa");
while ($qGetyear = mysql_fetch_array($resultyear, MYSQL_ASSOC)){
$Year = $qGetyear['year'];
$Niv1=$j;
if ($_SESSION['sessType']=='J')
{$qAffaire = " SELECT affnom, affno FROM affaire WHERE afsiret<>'' and (affaire.afjuge='".$_SESSION['sessCode']."')";}
if ($_SESSION['sessType']=='A')
{$qAffaire = "SELECT affnom, affno FROM affaire WHERE afsiret<>'' and (affaire.afjuge='".$Juge."')";}
$qAffaire .= " and extract(YEAR from afdatj1)='".$Year."' order by affnom";
$resultaffaire = mysql_query($qAffaire);
while ($qGetaffaire = mysql_fetch_array($resultaffaire, MYSQL_ASSOC)){
$_SESSION['Affnom'] = $qGetaffaire['affnom'];
$_SESSION['Affno'] = $qGetaffaire['affno'];
$_SESSION['Affnom'] = htmlspecialchars("$Affnom", ENT_QUOTES);
$j=$j+1;
} |
Partager