[mysql] jak wybrac rekordy "z pomiedzy" Opcje

[AndyPSV]

Jak wybrac te rekordy "spomiedzy" logd: 1 do 1?

[SQL] pobierz, plaintext 
	id_u	date 	ip	logd
			1	2010-11-05 12:17:34	127.0.0.1	1 /**** to pominac
			1	2010-11-05 12:17:29	127.0.0.1	0 /*** OD TAD
			1	2010-11-05 12:17:19	127.0.0.1	0
			1	2010-11-05 12:17:18	127.0.0.1	0
			1	2010-11-05 12:17:17	127.0.0.1	0
			1	2010-11-05 12:17:16	127.0.0.1	0
			1	2010-11-05 12:17:15	127.0.0.1	0
			1	2010-11-05 12:17:14	127.0.0.1	0
			1	2010-11-05 12:17:13	127.0.0.1	0
			1	2010-11-05 12:17:13	127.0.0.1	0 **** DO TAD WYBRAC TE REKORDY */
			1	2010-11-05 12:17:12	127.0.0.1	1
[SQL] pobierz, plaintext 

[AndyPSV]

ten kod mi wyswietla 1, co nie jest prawidlowa wartoscia (powinno byc 4)
jak wstawic ta "procedure"? wszedzie szukalem ale pewnie cos zle robie, bo nikt tych "procedur" w kodzie php nie podaje;


pomozcie mi to zrobic, bo juz mnie
(IMG:http://img209.imageshack.us/img209/3903/kurrrrr.gif)


-----------------------------------------------------------------------------

w koncu

[SQL] pobierz, plaintext 
$q = q('SELECT m.*
     , COUNT(n.id_u) total
  FROM
     (
SELECT a.date AS start
     , MIN(c.date) end
     , a.logd
     , a.ip
  FROM 
     ( SELECT x.date
            , x.ip
            , x.logd
            , COUNT(*) id 
         FROM chcur_logd x
         JOIN chcur_logd y
           ON y.date <= x.date
        GROUP BY x.date
     ) AS a
  LEFT JOIN 
     ( SELECT x.date
            , x.ip
            , x.logd, COUNT(*) id 
         FROM chcur_logd x
         JOIN chcur_logd y
           ON y.date <= x.date
        GROUP BY x.date
     ) AS b ON a.id = b.id + 1 AND b.logd = a.logd AND b.ip = a.ip
  LEFT JOIN  
     ( SELECT x.date
            , x.ip
            , x.logd
            , COUNT(*) id 
         FROM chcur_logd x
         JOIN chcur_logd y
           ON y.date <= x.date
        GROUP BY x.date
     ) c ON a.id <= c.id AND c.logd = a.logd  AND c.ip = a.ip
  LEFT JOIN 
     ( SELECT x.date
            , x.ip
            , x.logd
            , COUNT(*) id 
         FROM chcur_logd x
         JOIN chcur_logd y
           ON y.date <= x.date
        GROUP BY x.date
     ) AS d ON c.id = d.id - 1 AND d.logd = c.logd AND d.ip = c.ip
 WHERE b.id IS NULL 
   AND c.id IS NOT NULL 
   AND d.id IS NULL
 GROUP 
    BY start
     ) m
  JOIN chcur_logd n
    ON n.date BETWEEN m.start AND m.end
 GROUP
    BY m.start
HAVING m.logd = 1
 ORDER
    BY m.start LIMIT 1;');
			IF(n_r($q) > 0) $logd = f($q); var_export($logd);
[SQL] pobierz, plaintext 

Ten post edytował AndyPSV 26.11.2010, 02:32:13