$req = 'SELECT COUNT( id_click ) AS nb, DATE_FORMAT( date_click, "%Y-%m-%d" ), DATE(date_click) AS machin FROM opens GROUP BY machin'; $req=mysql_query($req) or die('Erreur SQL !'.$req.mysql_error()); while ($ligne=mysql_fetch_array($req)) { echo " Il y a eu ".$ligne[0]." clic(s) le jour ".$ligne[machin].". "; }
Il y a eu 8 clic(s) le jour 2010-01-21. Il y a eu 1 clic(s) le jour 2010-01-30. Il y a eu 1 clic(s) le jour 2010-02-08. Il y a eu 1 clic(s) le jour 2010-02-14. Il y a eu 1 clic(s) le jour 2010-02-18. Il y a eu 1 clic(s) le jour 2010-03-06. Il y a eu 1 clic(s) le jour 2010-03-08. Il y a eu 2 clic(s) le jour 2010-03-31.
DROP TABLE IF EXISTS opens; CREATE TABLE IF NOT EXISTS opens ( id_click int(6) NOT NULL auto_increment, usermail varchar(100) NOT NULL default '', date_click datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id_click) ) TYPE =MyISAM AUTO_INCREMENT=17 ; INSERT INTO opens (id_click, usermail, date_click) VALUES (1, '', '2010-01-21 11:16:14'), (2, '', '2010-01-21 11:16:34'), (3, '', '2010-01-21 11:16:40'), (4, '', '2010-01-21 11:16:45'), (5, '', '2010-01-21 11:16:54'), (6, '', '2010-01-21 11:25:31'), (7, '', '2010-01-21 11:25:40'), (8, '', '2010-01-21 11:25:41'), (9, '', '2010-01-30 14:49:18'), (10, '', '2010-02-08 11:20:11'), (11, '', '2010-02-14 08:14:51'), (12, '', '2010-02-18 10:37:19'), (13, '', '2010-03-06 12:27:16'), (14, '', '2010-03-08 20:14:03'), (15, '', '2010-03-31 06:01:20'), (16, '', '2010-03-31 06:01:20');
while ($ligne=mysql_fetch_array($req)) { echo " >> ".$ligne[0].">_> ".$nb." "; }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question"1";"2010-01-21" "1";"2010-01-21" "1";"2010-01-21" "1";"2010-01-21" "1";"2010-01-21" "1";"2010-01-21" "1";"2010-01-21" "1";"2010-01-21" "1";"2010-01-30" "1";"2010-02-08" "1";"2010-02-14" "1";"2010-02-18" "1";"2010-03-06" "1";"2010-03-08" "2";"2010-03-31"
DROP TABLE IF EXISTS opens; CREATE TABLE IF NOT EXISTS opens ( id_click int(6) NOT NULL auto_increment, usermail varchar(100) NOT NULL default '', date_click datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id_click) ) TYPE=MyISAM AUTO_INCREMENT=17 ; INSERT INTO opens (id_click, usermail, date_click) VALUES (1, '', '2010-01-21 11:16:14'), (2, '', '2010-01-21 11:16:34'), (3, '', '2010-01-21 11:16:40'), (4, '', '2010-01-21 11:16:45'), (5, '', '2010-01-21 11:16:54'), (6, '', '2010-01-21 11:25:31'), (7, '', '2010-01-21 11:25:40'), (8, '', '2010-01-21 11:25:41'), (9, '', '2010-01-30 14:49:18'), (10, '', '2010-02-08 11:20:11'), (11, '', '2010-02-14 08:14:51'), (12, '', '2010-02-18 10:37:19'), (13, '', '2010-03-06 12:27:16'), (14, '', '2010-03-08 20:14:03'), (15, '', '2010-03-31 06:01:20'), (16, '', '2010-03-31 06:01:20');
avec cette requete SELECT COUNT( id_click ) AS nb, DATE_FORMAT( date_click, "%Y-%m-%d" ) FROM opens GROUP BY SUBSTR(date_click,1,10) j'ai #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(date_click,1,10) LIMIT 0, 30' at line 2
while ($ligne=mysql_fetch_array($req)) { echo " le jour ".$ligne[0]." il y a eu ".$nb????." clics "; }
SELECT COUNT( id_click ) AS nb, DATE_FORMAT( date_click, "%Y-%m-%d" ) FROM opens GROUP BY DATE(date_click)
Erreur requête SQL: Documentation SELECT COUNT( id_click ) AS nb, DATE_FORMAT( date_click, "%Y-%m-%d" ) FROM opens GROUP BY DATE( date_click ) LIMIT 0 , 30 MySQL a répondu:Documentation #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(date_click) LIMIT 0, 30' at line 3
Qu'est ce que ça raconte si tu remplaces SUBSTR par SUBSTRING ?
tu es chez qui pour avoir une version aussi vieille ?
$req = "SELECT count(id_click) as nb, date_format(date_click, '%Y-%m-%d') from $tableOpens group by date_format(date_click, '%Y-%m-%d') order by date_format(date_click, '%Y-%m-%d') desc"; $req = "SELECT date_format(date_click, '%Y-%m-%d') as toto from $tableOpens group by date_format(date_click, '%Y-%m-%d') order by date_format(date_click, '%Y-%m-%d') desc"; $req = "SELECT COUNT(id_click) as nb, DATE_FORMAT(date_click, '%Y-%m-%d') FROM $tableOpens GROUP BY date_click"; $req = 'SELECT COUNT( id_click ) AS nb, DATE_FORMAT( date_click, "%Y-%m-%d" ) FROM opens GROUP BY DATE( date_click )'; $req = 'SELECT COUNT( id_click ) AS nb, DATE_FORMAT( date_click, "%Y-%m-%d" ) FROM opens GROUP BY SUBSTRING(date_click,1,10)'; $req=mysql_query($req) or die('Erreur SQL !'.$req.mysql_error()); while ($ligne=mysql_fetch_array($req)) { echo " >> ".$ligne[0].">_> ".$nb." "; } $nbtotal =mysql_query("SELECT count(id_click) as nb from $tableOpens"); $nbtotal =mysql_fetch_array($nbtotal) ; echo " Il y a eu au total ".$nbtotal["nb"]." clics.";
Est ce possible d'avoir une réponse à ma question ? :
tu es chez qui pour avoir une version aussi vieille ?
je pensais avoir posté ma réponse il y a longtemps
SELECT COUNT( id_click ) AS nb,
DATE_FORMAT( date_click, "%Y-%m-%d" ),
DATE(date_click) AS machin
FROM opens
GROUP BY machin