probléme avec while ($qGetyear = mysql_fetch_array($resultyear, MYSQL_ASSOC))
Bonjour à tous j'ai un petit problème avec un code que voici
Code:
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;
} |
je pense pas avoir oublié un truc important cela dit il rentre pas dutout dans les 2 boucles while :(:(
je comprend pas d'où viens le problème
