Finding if something isn't the same then outputing it.

Skull

ok, basically I want to take two rows out of a table

NAME and IP

If the NAME row is the same but the IP is different for some then it will echo out the NAME and IP and if they are all the same then it won't do anything

I thought of doing

$SQL = "SELECT * FROM admin_logged WHERE NAME!='$name' and IP='$ip' ORDER BY -ID";

but first I would need to find the name and I dunno how I could do that since it would only find the first name then stop, so if someone could maybe point me in the right direction then it would he aprreciated

barand

Does your database support subqueries?

Skull

I have no idea....how could I find out?

barand

If this works, it does support subqueries. If not, you need a temp table or resort to php code

SELECT  p.name , p.ip FROM person p
WHERE EXISTS (SELECT q.ip FROM person q
WHERE p.name = q.name AND p.ip <> q.ip)
ORDER BY p.name

hth

Skull

i get the following error

You have an error in your SQL syntax near 'EXISTS (SELECT q.ip FROM person q WHERE p.name = q.name AND p.ip <> q.ip) ORDE' at line 3

laserlight

probably need a comma between "person" and "q"

Skull

same error, just with a comma in-between

barand

q is the alias for the 2nd reference to person, so no comma.

Seems like it doesn't like EXISTS (subquery expression).

The following sequence of queries should dig out duplicates.

CREATE temp_ip (name varchar(50), ip varchar(16));

INSERT INTO temp_ip SELECT DISTINCT name, ip FROM person;

SELECT name , COUNT(*) as num_ip FROM temp_ip GROUP BY name HAVING num_ip > 1;

//process names here

DROP TABLE temp_ip;

hth