get all fields value from mysql using php

Question

hi

i want to know how to get all fields value search by array.

i have array that s

my table is

  id   content

  1    zahr
  2    hai
   .
   .
   .
  and so on


$a = {2,3,4,5,43,32};

i have to take the contents by this id(from array "a").

i know, i can use "for" loop for getting each element from mysql.

but i would like to use any filters or any predefined function

thanks and advance

Answer 1

SELECT * FROM table WHERE id IN (2,3,4,5,43,32)

the statement could be created by using implode like:

$myvar = '('.implode(',',$a).')';

and then

SELECT * FROM table WHERE id IN $myvar

Answer 2

use IN