function Pure($s) {return get_magic_quotes_gpc() ? $s : mysql_real_escape_string($s);}
"SELECT * FROM matable WHERE champStr ='" . Pure($champStr) . "' AND champInt= " . (int)$champInt
"SELECT COUNT(c.element) AS NBRE_ELEMENT_MOIS FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id
WHERE MONTH(d.date_appel)=".(int)$mois." AND YEAR(d.date_appel)=".(int)$annee." AND ENSEMBLE = '".Pure($ensemble)."'
GROUP BY ELEMENT ORDER BY ENSEMBLE"
while ($req3 = mysql_fetch_assoc($reqElementAnnee))
{
if (!($req4 = mysql_fetch_assoc($reqElement))) die("argh");
//[...]
}
SELECT c.id, c.id_appel, d.date_appel, d.batiment, SUM( c.ensemble ) AS NBRE_ENSEMBLE, c.ensemble FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH(d.date_appel)=$mois AND YEAR( d.date_appel )=$annee GROUP BY d.batiment ORDER BY d.batiment
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT c.id, c.ensemble, COUNT( c.element ) AS NBRE_ELEMENT, c.element, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH( d.date_appel ) = $mois AND YEAR( d.date_appel ) = $annee GROUP BY c.ensemble, c.element ORDER BY c.ensemble, c.element
$req=mysql_query("SELECT * FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id ORDER BY c.id"); while ($datas = mysql_fetch_assoc($req)) { }
$req=mysql_query("SELECT c.id as idCorrectif, * FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id ORDER BY c.id");
<?php require_once('connexionbdd.php'); // Connexion à mysql via le fichier connexion.php $reqEnsemble=mysql_query("SELECT c.ensemble, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH( d.date_appel )=$mois AND YEAR( d.date_appel )=$annee GROUP BY c.ensemble ORDER BY c.ensemble"); while ($req1 = mysql_fetch_assoc($reqEnsemble)) { echo '<tr>'; echo '<td align="center">'.htmlentities($req1['c.ensemble']).'</td>'; $reqElement=mysql_query("SELECT c.id, c.ensemble, COUNT( c.element ) AS NBRE_ELEMENT, c.element, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH( d.date_appel )=$mois AND YEAR( d.date_appel )=$annee AND c.ensemble = $req1['ensemble'] GROUP BY c.element ORDER BY c.element"); while ($req2 = mysql_fetch_assoc($reqElement)) { echo ' '; echo htmlentities($req2['c.element']); echo '<td align="center">'.htmlentities($req1['NBRE_ELEMENT']).'</td>'; echo '</tr>'; } } ?>
$reqElement=mysql_query("SELECT c.id, c.ensemble, COUNT( c.element ) AS NBRE_ELEMENT, c.element, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH( d.date_appel )=$mois AND YEAR( d.date_appel )=$annee AND c.ensemble = {$req1['ensemble']} GROUP BY c.element ORDER BY c.element");
<col style= \"width:60%\"> <col style=\"width:20%\"> <col style=\"width:20%\"> ---- TYPE DE MATERIEL | <?php echo $moislettre ?> | CUMUL <?php echo $annee ?> | <?php require_once('connexionbdd.php'); // Connexion à mysql via le fichier connexion.php $reqEnsemble =mysql_query(\"SELECT c.ensemble AS ENSEMBLE, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH(d.date_appel)=$mois AND YEAR(d.date_appel)=$annee GROUP BY ENSEMBLE ORDER BY ENSEMBLE\") or die(mysql_error()); while ($req1 = mysql_fetch_assoc($reqEnsemble)) { echo '---- '; echo ''.htmlentities($req1['ENSEMBLE']).', '; $reqElement=mysql_query(\"SELECT c.idCorrectif, c.ensemble AS ENSEMBLE, COUNT(c.element) AS NBRE_ELEMENT, c.element AS ELEMENT, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH( d.date_appel )=$mois AND YEAR( d.date_appel )=$annee AND ENSEMBLE = {$req1['ENSEMBLE']} GROUP BY ELEMENT ORDER BY ENSEMBLE\"); while ($req2 = mysql_fetch_assoc($reqElement) or die(mysql_error())) { echo ' '; echo htmlentities($req2['ELEMENT']); echo ''.htmlentities($req1['NBRE_ELEMENT']).', '; echo ''; } } ?>
$ensemble = mysql_real_escape_string($req1['ENSEMBLE']);
$reqElement=mysql_query("[...]ENSEMBLE = '$ensemble' GROUP BY ELEMENT ORDER BY ENSEMBLE");
<col style= \"width:60%\"> <col style=\"width:20%\"> <col style=\"width:20%\"> ---- TYPE DE MATERIEL | <?php echo $moislettre ?> | CUMUL <?php echo $annee ?> | <?php require_once('connexionbdd.php'); // Connexion à mysql via le fichier connexion.php $reqEnsemble =mysql_query(\"SELECT c.ensemble AS ENSEMBLE, d.date_appel, COUNT(c.element) AS NBRE_ELEMENT FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH(d.date_appel)=$mois AND YEAR(d.date_appel)=$annee GROUP BY ENSEMBLE ORDER BY ENSEMBLE\") or die(mysql_error()); while ($req1 = mysql_fetch_assoc($reqEnsemble)) { echo '---- '; echo ''.htmlentities($req1['ENSEMBLE']).', '; echo ''.htmlentities($req1['NBRE_ELEMENT']).', '; echo ''; $ensemble = mysql_real_escape_string($req1['ENSEMBLE']); $reqElement=mysql_query(\"SELECT c.idCorrectif, c.ensemble AS ENSEMBLE, COUNT(c.element) AS NBRE_ELEMENT, c.element AS ELEMENT, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH( d.date_appel )=$mois AND YEAR( d.date_appel )=$annee AND ENSEMBLE = '$ensemble' GROUP BY ELEMENT ORDER BY ENSEMBLE\"); while ($req2 = mysql_fetch_assoc($reqElement) or die(mysql_error())) { echo '---- '; echo ''.htmlentities($req2['ELEMENT']).', '; echo ''.htmlentities($req2['NBRE_ELEMENT']).', '; echo ''; } } ?>
require_once('connexionbdd.php'); // Connexion à mysql via le fichier connexion.php $reqEnsemble=mysql_query("SELECT c.ensemble AS ENSEMBLE, d.date_appel, COUNT(c.element) AS NBRE_ELEMENT_MOIS FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH(d.date_appel)=$mois AND YEAR(d.date_appel)=$annee GROUP BY ENSEMBLE ORDER BY ENSEMBLE"); $reqEnsembleAnnee=mysql_query("SELECT c.ensemble AS ENSEMBLE, d.date_appel, COUNT(c.element) AS NBRE_ELEMENT_ANNEE FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE YEAR(d.date_appel)=$annee GROUP BY ENSEMBLE ORDER BY ENSEMBLE"); while ($req1 mysql_fetch_assoc($reqEnsembleAnnee) && $req2 mysql_fetch_assoc($reqEnsemble)) { echo '<tr>'; echo '<td align="left" style="background-color:yellow">'.htmlentities($req1['ENSEMBLE']).'</td>'; echo '<td align="center" style="color:red; font-weight:bold; background-color:yellow">'.htmlentities($req2['NBRE_ELEMENT_MOIS']).'</td>'; echo '<td align="center" style="color:blue; font-weight:bold; background-color:yellow">'.htmlentities($req1['NBRE_ELEMENT_ANNEE']).'</td>'; echo '</tr>'; $ensemble = mysql_real_escape_string($req2['ENSEMBLE']); $ensemble_annee = mysql_real_escape_string($req1['ENSEMBLE']); $reqElement=mysql_query("SELECT c.idCorrectif, c.ensemble AS ENSEMBLE, COUNT(c.element) AS NBRE_ELEMENT_MOIS, c.element AS ELEMENT, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE MONTH( d.date_appel )=$mois AND YEAR( d.date_appel )=$annee AND ENSEMBLE = '$ensemble' GROUP BY ELEMENT ORDER BY ENSEMBLE"); $reqElementAnnee=mysql_query("SELECT c.idCorrectif, c.ensemble AS ENSEMBLE, COUNT(c.element) AS NBRE_ELEMENT_ANNEE, c.element AS ELEMENT, d.date_appel FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id WHERE YEAR( d.date_appel )=$annee AND ENSEMBLE = '$ensemble_annee' GROUP BY ELEMENT ORDER BY ENSEMBLE"); while ($req3 mysql_fetch_assoc($reqElementAnnee) && $req4 mysql_fetch_assoc($reqElement)) { echo '<tr>'; echo '<td align="right">'.htmlentities($req3['ELEMENT']).'</td>'; echo '<td align="center">'.htmlentities($req4['NBRE_ELEMENT_MOIS']).'</td>'; echo '<td align="center">'.htmlentities($req3['NBRE_ELEMENT_ANNEE']).'</td>'; echo '</tr>'; } }