|
|
|
|
Bonjour,
j'ai un problème avec ce code je vois pas l'erreur??
J'esseil de récupérer une date et avec cette date j'affiche les différent éléments dont j'ai besoin mais sa marche pas :( si vous pouvez me donner votre avis ce serait gentille merci car j'arrive pas a trouvé mon erreur je pense que j'ai du fair une erreur dans le if??
if (isset($date_du) && isset($date_au)) {
$query_vg = mysql_query("SELECT IF(customers_from LIKE '1st%','1rst',customers_from) AS Origin,
COUNT(*) AS effectif_vg
FROM customers inner join relances_gratuites on customers.customers_id=relances_gratuites.customers_id
WHERE customers_client='0'
AND customers_emv='0'
AND customers_seance ='0'
AND relances_gratuites_inscription_date>='" . $date_du . "' and relances_gratuites_inscription_date<='" . $date_au . "'
GROUP BY Origin ");
and
$query = mysql_query("SELECT IF(cu.customers_from LIKE '1st%','1rst',cu.customers_from) AS Origin,
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
INNER JOIN relances_gratuites rg
ON cu.customers_id=rg.customers_id
WHERE co.commandes_status='1'
AND rg.relances_gratuites_inscription_date>='" . $date_du . "' AND rg.relances_gratuites_inscription_date<='" . $date_au . "'
GROUP BY Origin ";
} else if (isset($date_du) && $date_du != '') {
$query_vg = mysql_query("SELECT IF(customers_from LIKE '1st%','1rst',customers_from) AS Origin,
COUNT(*) AS effectif_vg
FROM customers inner join relances_gratuites on customers.customers_id=relances_gratuites.customers_id
WHERE customers_client='0'
AND customers_emv='0'
AND customers_seance ='0'
AND relances_gratuites_inscription_date>='" . $date_du . "'
GROUP BY Origin ");
and
$query = mysql_query("SELECT IF(cu.customers_from LIKE '1st%','1rst',cu.customers_from) AS Origin,
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
INNER JOIN relances_gratuites rg
ON cu.customers_id=rg.customers_id
WHERE co.commandes_status='1'
AND rg.relances_gratuites_inscription_date>='" . $date_du . "'
GROUP BY Origin");
}
else (isset($date_au) && $date_au != '') {
$query_vg = mysql_query("SELECT IF(customers_from LIKE '1st%','1rst',customers_from) AS Origin,
COUNT(*) AS effectif_vg
FROM customers inner join relances_gratuites on customers.customers_id=relances_gratuites.customers_id
WHERE customers_client='0'
AND customers_emv='0'
AND customers_seance ='0'
AND relances_gratuites_inscription_date>='" . $date_au . "'
GROUP BY Origin ");
and
$query = mysql_query("SELECT IF(cu.customers_from LIKE '1st%','1rst',cu.customers_from) AS Origin,
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
INNER JOIN relances_gratuites rg
ON cu.customers_id=rg.customers_id
WHERE co.commandes_status='1'
AND rg.relances_gratuites_inscription_date>='" . $date_au . "'
GROUP BY Origin");
}
Configuration: Windows XP Firefox 3.0.10
Ton code n'est pas du tout logique je trouve mais bon ...
<?php
if (isset($date_du) && isset($date_au))
{
$query_vg = mysql_query("SELECT IF(customers_from LIKE '1st%','1rst',customers_from) AS Origin,
COUNT(*) AS effectif_vg
FROM customers inner join relances_gratuites on customers.customers_id=relances_gratuites.customers_id
WHERE customers_client='0'
AND customers_emv='0'
AND customers_seance ='0'
AND relances_gratuites_inscription_date>='" . $date_du . "' and relances_gratuites_inscription_date<='" . $date_au . "'
GROUP BY Origin ");
$query = mysql_query("SELECT IF(cu.customers_from LIKE '1st%','1rst',cu.customers_from) AS Origin,
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
INNER JOIN relances_gratuites rg
ON cu.customers_id=rg.customers_id
WHERE co.commandes_status='1'
AND rg.relances_gratuites_inscription_date>='" . $date_du . "' AND rg.relances_gratuites_inscription_date<='" . $date_au . "'
GROUP BY Origin ";
if (isset($date_du) && $date_du != '')
{
$query_vg = mysql_query("SELECT IF(customers_from LIKE '1st%','1rst',customers_from) AS Origin,
COUNT(*) AS effectif_vg
FROM customers inner join relances_gratuites on customers.customers_id=relances_gratuites.customers_id
WHERE customers_client='0'
AND customers_emv='0'
AND customers_seance ='0'
AND relances_gratuites_inscription_date>='" . $date_du . "'
GROUP BY Origin ");
$query = mysql_query("SELECT IF(cu.customers_from LIKE '1st%','1rst',cu.customers_from) AS Origin,
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
INNER JOIN relances_gratuites rg
ON cu.customers_id=rg.customers_id
WHERE co.commandes_status='1'
AND rg.relances_gratuites_inscription_date>='" . $date_du . "'
GROUP BY Origin");
}
if(isset($date_au) && $date_au != '')
{
$query_vg = mysql_query("SELECT IF(customers_from LIKE '1st%','1rst',customers_from) AS Origin,
COUNT(*) AS effectif_vg
FROM customers inner join relances_gratuites on customers.customers_id=relances_gratuites.customers_id
WHERE customers_client='0'
AND customers_emv='0'
AND customers_seance ='0'
AND relances_gratuites_inscription_date>='" . $date_au . "'
GROUP BY Origin ");
$query = mysql_query("SELECT IF(cu.customers_from LIKE '1st%','1rst',cu.customers_from) AS Origin,
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
INNER JOIN relances_gratuites rg
ON cu.customers_id=rg.customers_id
WHERE co.commandes_status='1'
AND rg.relances_gratuites_inscription_date>='" . $date_au . "'
GROUP BY Origin");
}
}
?>
Les gens qui disent que windows est pourri et qui continuent de l'utiliser me font bien rire ...
95 % des erreurs proviennent de ce qu'il y a entre le clavier et la chaise |
Répondre à sinifer
|
Pour ceu que sa intéresserai
$condition = "";
if (isset($date_du) && !empty($date_du)) {
$condition .= " AND rg.relances_gratuites_inscription_date>='" . $date_du . "' ";
}
if (isset($date_au) && !empty($date_au)) {
$condition .= " AND rg.relances_gratuites_inscription_date<='" . $date_au . "' ";
}
$query_vg = mysql_query("SELECT IF(customers_from LIKE '1st%','1rst',customers_from) AS Origin,
COUNT(*) AS effectif_vg
FROM customers c inner join relances_gratuites rg on c.customers_id=rg.customers_id
WHERE customers_client='0'
AND customers_emv='0'
AND customers_seance ='0'
" . $condition . "
GROUP BY Origin " );
$query = mysql_query("SELECT IF(cu.customers_from LIKE '1st%','1rst',cu.customers_from) AS Origin,
COUNT(DISTINCT cu.customers_id) AS effectif, count(co.commandes_status) AS command,
AVG(co.commandes_montant) AS Mmc
FROM customers cu
INNER JOIN commandes co
ON cu.customers_id=co.customers_id
INNER JOIN relances_gratuites rg
ON cu.customers_id=rg.customers_id
WHERE co.commandes_status='1'
" . $condition . "
GROUP BY Origin " );
|
Access recordset avec une requête Access requete date And et or dans une même if And et or dans une même if php Bash if Ce tracker supporte plusieurs hash par requete Condition if en java Dd if= If matlab Incrémenter requete access Linux enchainer requete Perl if Requete insert sous access Requete multicritere php select Requete sql pour afficher date courant Requette sql boucle tableau Requête sql compliques Requête sql définition
