I need to combine 2 queries

[thecard]

I have 2 queries, I wrote one of them, and found the other on the internet as I find it preety confusing!

I need to make them cause and effect:

The first:

$dothis = mysql_query("SELECT * FROM tb_users tb WHERE EXISTS(SELECT tb2.ip FROM tb_users tb2 WHERE tb.ip=tb2.ip AND tb.username<>tb2.username) order by ip") or die (mysql_error());

The second:

$thisagain= mysql_query("UPDATE tb_users SET suspen='logged'") or die (mysql_error());

So basically if there is a duplicated ip of a users, I need all their account's "suspens" to be logged.

Sorry, I'm a bit of a noob.

I've tried changing select to UPDATE and loads of other stuff.

[fenway]

I'm very confused... you want to run the update for only the matching users from the select? Your current update has no where clause!`

[thecard]

I want to do this with a mysql query:

 

Search for users who have the same ip address.

Update these user's accounts.

[fenway]

Did you try (UNTESTED):

 

UPDATE tb_users tb WHERE EXISTS(SELECT tb2.ip FROM tb_users tb2 WHERE tb.ip=tb2.ip AND tb.username<>tb2.username) SET tb.suspen='logged'