Код:
| SELECT login, COUNT(1) AS cnt FROM users GROUP BY ip HAVING cnt > 1 |
| SELECT login, COUNT(1) AS cnt FROM users GROUP BY ip HAVING cnt > 1 |
| $a=mysql_query("SELECT login, COUNT(1) AS cnt FROM users GROUP BY ip HAVING cnt > 1"); |
| while ($b = mysql_fetch_array($a)){ |
| echo $b['login'].'<br/>'; |
| } |
| $q = mysql_query('SELECT GROUP_CONCAT(login) AS logins, ip, COUNT(1) AS cnt FROM users GROUP BY ip HAVING cnt > 1'); |
| while ($row = mysql_fetch_assoc($a)) { |
| echo $row['logins'] . '<br/>'; |
| } |