freeublue Posted June 20, 2012 Share Posted June 20, 2012 Hi, I need to make a selection from my database where ip is unique, and the query selects the the name of the page viewed based on the quanity of each page id this is what I have come up with is it correct. (P.S each view may only be summed if the ip is diffrent???).. $qe = "SELECT * FROM cou WHERE num = '$r'"; for a array_sum for total views. $q = "SELECT Distinct ip, ot1, COUNT(num) FROM cou WHERE num = '$r' GROUP BY ot1"; num is the username, ot1 is the page name and id, while ip is (You guessed it ) the ip address of the browser. Link to comment https://forums.phpfreaks.com/topic/264513-mysql-query/ Share on other sites More sharing options...
Barand Posted June 21, 2012 Share Posted June 21, 2012 if you want unique ip then ... GROUP BY ip HAVING COUNT(NUM) = 1 Link to comment https://forums.phpfreaks.com/topic/264513-mysql-query/#findComment-1355978 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.