PHP mysql fetch array

[tomcat01]

Hi all

 

Need some help with the following please:

I want to fetch data from mysql but the id is part of an array

 

$ids = array("1","2","3");

$sql = mysql_query("SELECT * FROM table WHERE id ='$ids'") or die ("Error". mysql_error() );

 

This gives an obvious error but how can I get it to return the rows having ids 1 ,2 and 3 only! - It must not give me ids 5, 101 or 5 aswell should they exist. The array can be 20 values so I cant build it into the select.

 

Hope you understand what I'm looking for.

Please help me out on this one.Thanks

[worldworld]

You must have for loop before $sql....

[xec]

Hii,

 

    use this code

 

 

$ids = array("1","2","3");

 

foreach($ids as $i)

{

$sql = mysql_query("SELECT * FROM table WHERE id ='$i'") or die ("Error". mysql_error() );

$res[] = mysql_fetch_array($sql);

}

 

[kalai]

Hi ,

 

Instead of running the loop many times,

 

Keep your values in a string ,

$ids = "1,2,3";

 

$sql = mysql_query("select * from table where id in (".$ids.")");

$data [] = mysql_fetch_array($sql);