array intersect...

[mlewczuk]

Hello group,
I'm using mySql in my app, and this database don't provide functions like INTERSECT or MINUS.

So I need some alternative solution for this. I'm thinkig about array_intersect but unfortunately I don't know anything about arrays. So maybe you will help me with this...

db SELECT give me two groups of numbers:

A -> 43,44,87
B -> 42,43,44

Now, how can I make two arrays, and intersect them -> in the result I shoud be given this: 43,44.

How can I do it ?

[bastien]

can you use UNION to pull out those values?

also look at array_search()
http://www.php.net/manual/en/function.array-search.php

loop through first array to search for matching values in second dataset

hth