Array Comparisons

Anon

I have two separate single dimensional arrays, both containing worker names. Both arrays are generated from separate SQL statements. Array A has a full list of workers in a comma-delimited format, Array B has a list of X number of workers. I need for Array A to compare itself with Array B and only display those workers that don't show up in Array B.

My main problem is when I'm comparing them they output twice when the comparison loop has more than one name in Array B. Any advice?

amcgrath

Can you paste the code you have with the problem?

[deleted]

"Both arrays are generated from separate SQL statements. "

Wouldn't it make more sense to change the query to get the output you want?
an array with comma delimited data?

gio2k

Why don't you just create a sql query to get the list of workers directly form your database?

-Gio-

Anon

I've only been doing PHP4 for about a month now, so I'm nowhere near fully streamlining the code at all, or utilizing necessarily effective methods of SQL retrival.

How would I change the query so it reflects two different tables of data and compares them in my aforementioned situation?
How else would the array contain data? Quotes or spaces? Should that matter?

Anon

Because my code is ridiculously bulky and inefficient, I'll supply you with the two SQL statements I'm using to retrieve the data with.

<?
// retrieves workers associated to given bug issue
$sql_bugowners = "select * from bugandowner where bugownerid = '$id'";
$result_bugowners = mysql_query($sql_bugowners);

//retrieves full list of workers
$sql_workers = "select fname, lname from user order by lname, fname";
$result_workers = mysql_query($sql_workers);
?>

Array A will be the results from $sql_bugowners, Array B will be the results from $sql_workers. How to only show workers from Array B that don't appear in Array A

amcgrath

You could combine the two using the EXCEPT statement.

Storing a comma list in an array is kinda dumb. Store each value in an index of the array.

Anon

If I were to use the EXCEPT statement, how would I get it to work for multiple names?

[deleted]

The point of an array is that each element contains a single value.

Read the docs!

phigga

What is the table structure for bugandowner? I'm sure that there's a single sql statement that'll do what you want.