SELECT value which matches array element?

[ckey]

Hi,
I want to create a SELECT query which select these values which are matching to one element of a two dimensional array.

e.g.

--- name ------ menu_id --

.... paul .. | ..... 3 ...
. johanna .. | ..... 2 ...
.... marc .. | ..... 4 ...

-------------------------------------

my_array[0][0]=3
my_array[1][0]=2

Now I want to select paul and johanna because their menu_id matches with these two array elements of my_array.

How do I have to setup the SELECT query?

---

regards, ckey

[eriksmoen]

use the LIKE statement...

mysql_query("SELECT * FROM table_name WHERE menu_id LIKE '%".$my_array[$a][$b]."%' ORDER BY name DESC")

hope that helps...