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 Quote Link to comment 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` Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.