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. Quote Link to comment 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 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.