Hi. Sorry for my english (is not good)
I have sql query for get all results by some parameters:
$sql_string = 'SELECT SQL_CALC_FOUND_ROWS ip_ip, ip_time, ip_location, ip_referer, ip_username, ip_user_type, ip_browser FROM ' . IP_TRACK_TABLE;
Is for phpbb3, but it does not matter now.
In this table have 7000 rows with different information. (this is problem)
It logged username, ips and etc.. for user sessions.
I need to get only user information with different ips (ONLY THIS)
Now i have 200-300 rows with ips which are the same. (i dont want this)
I need to get only user information with different ip where column ip_ip have some different ips (not only the same)
Now some example:
if username: Ivan have 200 rows with ip 127.0.0.1 - i dont need to get this row in select query.
But if Todor have 200 rows logged in db with ip 127.0.0.1 and 127.0.0.2 (in ip_ip column) - i need to catch this and print in page.
Please, if someone know how to do that - help me.
Edited by grakovski