Remove values from a flat array if found as a column value in a multi-row query result set

Question

I'm trying to use array_diff to compare a list of values pulled from a table with one I set manually and it's not working, not even close. It's like it doesn't recognise the array I build from the query, and just outputs array1 unchanged. Any idea where i'm going wrong? I've tried putting them the other way around, i've tried different ways of building array2 in the query, and nothing seems to help.

$open_positions_query = "SELECT position FROM ship_positions WHERE ship_id = '$ship_id'";
$open_positions_result = mysqli_query($mysqli, $open_positions_query);
while ($open_positions_array = mysqli_fetch_row($open_positions_result))
{
   $array2[] = array($open_positions_array);
}

$array1 = array("CO", "XO", "OPS", "NAV", "CTO", "TAC", "CMO", "MED", "CSO", "SCI", "CEO", "ENG", "CIV");   

$arrayresult = array_diff($array1, $array2);

I've got it outputting elsewhere, and right now it just outputs array1 unchanged. If I put this in though, it outputs the correct difference.

$array2 = array("CO", "XO", "OPS", "NAV", "CTO", "TAC", "CMO", "SCI", "CEO");

Take a look at the contents of $array2 using var_dump($array2). It will be a multi-dimensional array, which is not what you want for comparing to $array1. — Dave
– Dave, Commented Jan 6, 2014 at 20:08
The way you construct $array2, it will never be a flat list of values. it will be an array of arrays containing your DB values. Better use $array2[] = $open_positions_array[$whatever_indice_you_need]; — kuroi neko
– kuroi neko, Commented Jan 6, 2014 at 20:12

Paul · Accepted Answer · 2014-01-06 20:09:19Z

2

Try this :

while ($open_positions_array = mysqli_fetch_row($open_positions_result))
{
   $array2[] = $open_positions_array['position'];
}

answered Jan 6, 2014 at 20:09

Paul

7852 gold badges14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Cthulhuite Over a year ago

This worked fantastically. I had to changed it to "mysqli_fetch_array" on the while line, otherwise it pulled Null values, but after that it worked a treat. You are all magnificent, thank you!

Collectives™ on Stack Overflow

Remove values from a flat array if found as a column value in a multi-row query result set

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related