php missing duplicates

[FrankieHouse]

Hi i'm sure there is any easy answer to this but hopefully someone can point me in the right direction.

I have an array with id numbers, sometimes there are duplicates in the array which is what i want. With these id numbers i'm doing a mysql query and pulling out an image link, the problem is that the results i get back from mysql aren't displaying the duplicates, so say i had 3 id 1's in the array i will only get back 1 image instead of the 3 if you get what i mean.

the code i have so far is this:

$addId = implode(",",$sessProduct);

$getSessionItems = mysql_query("SELECT * FROM products WHERE id IN ($addId)", $connection); 
    if(!$getSessionItems){
        die("Database Query Failed: " . mysql_error());
        }

 while ($row = mysql_fetch_array($getSessionItems)){
     echo $row["image"] . ", " . "</br>";
     } 

Can anyone tell me how i can get the duplicates as well?

Thanks

[borris83]

No, that won't be possible with 'IN' operator in sql...

Instead, you can try this way:

foreach $sessProduct as $key
 {
     $getSessionItems = mysql_query("SELECT * FROM products WHERE id = ' $key' ",    $connection);

        if(!$getSessionItems)
        {
        die("Database Query Failed: " . mysql_error());
        }


        while ($row = mysql_fetch_array($getSessionItems))
        {
        echo $row["image"] . ", " . "</br>";
        }  

 }

[FrankieHouse]

Dude your a superstar thanks alot