ryanfilard Posted December 6, 2011 Share Posted December 6, 2011 I have a mysql table with the columns ip, date, and page. How would I get the total number of rows with the same ip address. My Table: ip: date: page: 192.168.1.1 1.1.2011 1 192.168.1.1 1.1.2011 2 192.168.1.1 1.1.2011 3 192.168.1.1 1.1.2011 4 192.168.1.1 1.1.2011 3 192.179.1.1 1.1.2011 2 192.179.1.1 1.1.2011 7 192.179.1.1 1.1.2011 1 192.179.1.1 1.1.2011 2 All the IPs that are the same should be grouped together. mysql_num_rows should output 2 Link to comment https://forums.phpfreaks.com/topic/252550-get-unique-visitors/ Share on other sites More sharing options...
tomfmason Posted December 6, 2011 Share Posted December 6, 2011 should be as simple as using distinct in your query e.g SELECT DISTINCT `field` FROM `table` Link to comment https://forums.phpfreaks.com/topic/252550-get-unique-visitors/#findComment-1294785 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.