comparing array to database table results

gleemonex

Hi.

I am pulling rows from 2 databases with a

while ($row = mysql_fetch_array($result2)) {
                        echo '<li><input type="checkbox" name="food[]" value="'. $id . ','. $dataid['sname'] .','. $row['type'] .','. $row['name'] .','. $row['url'] .'" checked><span>' . $row['type'] . '</span></li>';
                        $selected[] = '(' . $row['name'] . ')';
                        }

                    if (count($result2) > 0) {
                            echo '<li><span>- - - - - - - - - - - - - - - - - </span></li>';
                            }

                    while ($row = mysql_fetch_array($result)) {
                    echo '<li><input type="checkbox" name="food[]" value="'. $id . ','. $dataid['sname'] .','. $row['type'] .','. $row['name'] .','. $row['url'] .'"><span>' . $row['name'] . '</span></li>';
                    }

As you can see they are seperated by a dotted line.
The top block pulls out all the rows for the user and echos the

<li>

with a checked checkbox.

The bottom block takes all the rows from the other table and makes

<li>

out of them all.

With this line:

$selected[] = '(' . $row['name'] . ')';

I'm creating an array with the data from the selected database table.

I would like to take this array and its values.. and check them inside the the second block's while loop. Any of the rows that have a matching value to one of the values in the array I would not like to echo.

I'm just confused on how to break apart the array an compare the row with every value in the array before it is echoed in the

<li>

Can someone help me fill in ther blanks?

onion2k

I'm not 110% certain I understand what you're doing, but:

if (in_array($id,$selected) {
//do stuff
}

..where $id is the id of your type in the second while loop, and $selected is an array of selected ids from the database..

That might help you along.

gleemonex

Ok, I changed gears a bit.. and decided to do the comparison before SELECTING from the database.

SELECT * FROM foodData WHERE (id != 12) AND name != 'steak' OR name != 'apple' OR name != 'pie' ORDER BY name

This is how i have it set up right now.

I want to SELECT every row in which

1) the id for that row is not 12
2) the name for that row is not steak, apple, or pie

I've played around with AND, and OR position.. but haven't nailed it down just yet.

Can someone help with the syntax?

bodzan

Try this:

SELECT * FROM foodData WHERE id != 12 AND name != 'steak' OR id != 12 AND name != 'apple' OR id != 12 AND name != 'pie' ORDER BY name

I figure it should work just fine...