comparing differences in results

[LordRogaine]

I'm using two slightly different scripts which output about 500 results each, give or take four or five extra with the second script. How can I compare the two scripts so that it shows me the four or five extra results(names) from the second script?

$script_1 = mysql_query("SELECT DISTINCT username_A, username_B FROM table_A, table_B where username_A = username_B");

$script_2 = mysql_query("SELECT DISTINCT username_A FROM table_A");

[pete_bisby]

SELECT DISTINCT username_B
FROM table_B OUTER JOIN table_A ON username_B=username_B
WHERE username_A IS NULL

[LordRogaine]

thanks but I'm not looking to rewrtie the coding. I would like to run both scripts, compare the results of both and print the names of the few that differ from eachother. Thanks.

[Weedpacket]

Put the results in arrays and use functions like [man]array_diff[/man] to find differences.