How to search in database where is array

Question

I've got this mysqlquery:

$Nusers = mysql_query("SELECT user_id FROM dotp_user_task_type WHERE user_task_types_id = '$select1'");
$row = mysql_fetch_array($result);

It takes all users id's which has task with specific id. So, now i need to take their name and last name but i don't know how to use WHERE when $row is array with numbers.

$Nusers = mysql_query("SELECT CONCAT(contact_first_name, ' ', contact_last_name) FROM dotp_user_contacts WHERE user_id = '$row'");

Help please.............

Answer 1

Try this..

Using IN to search array value in mysql

$datauserid=array();

    $Nusers = mysql_query("SELECT user_id FROM dotp_user_task_type WHERE user_task_types_id = '$select1'");

    while($row = mysql_fetch_array($Nusers))
{
$datauserid[]=$row['user_id'];
}
    $userid=implode(",",$datauserid);

    $Nusers = mysql_query("SELECT CONCAT(contact_first_name, ' ', contact_last_name) FROM dotp_user_contacts WHERE user_id IN ($userid)");