There is a table:

id - int(11) data - date url - text ip - text username - text referer - text

The task is as follows: output information from a table for a specific date, while grouping by the url field

That is, now request

 $stat = mysql_query("SELECT * FROM stat WHERE data = '".$data."'");

I derive such data for example

 1 2014-07-30 obmennik.ws 46.175.214.225 ref arashvg 2 2014-07-30 obmennik.ws 46.175.214.225 ref arashvg 3 2014-07-30 e-dengi.org 62.76.46.3 ref arashvg 4 2014-07-30 e-dengi.org 42.119.216.151 ref arashvg 5 2014-07-30 e-dengi.org 42.119.216.151 ref arashvg 6 2014-07-30 obmennik.ru 178.93.108.202 ref arashvg

I need to get:

 1 2014-07-30 obmennik.ws (2) 2 2014-07-30 e-dengi.org (3) 3 2014-07-30 obmennik.ru (1)

How can you get this?

  • About GROUP BY heard something? - DreamChild pm
  • one
    Something like that, probably: "SELECT data, url, count (id) FROM stat WHERE data = '". $ Data. "' Group by data, url" - Ivan Pleshkov
  • Thank! What you need! - arashvg 1:22 pm
  • > following !!! - etki pm
  • data - date url - text ip - text This is just a holiday of some kind :) - user6550

0