title: Using an array in a PHP MySQL WHERE clause
body: <p>Hi I am creating an array of user id's with a query. With another query I would like to select from a given table where the user_id is one that is in the array created from my very first query. How can I use an array in my WHERE clause?</p>
  
  <p>Just for reference: $row_interest is the array</p>
  
  <p>My Code:</p>
  
  <pre><code>//Grabs the user id's of the users that have the queried interest
  $interest_search_query= "SELECT DISTINCT user_id FROM interests WHERE interest LIKE   
  '%".$search_term."%'";
  $interest_search_result= mysqli_query($connect, $interest_search_query);
  $row_interest= mysqli_fetch_array($interest_search_result);
  
  //Grabs the user information with each user id
  $search_query= "SELECT DISTINCT user_id, fname, lname, profile_pic, school FROM users   
  WHERE user_id IN $row_interest";
  </code></pre>
  
  <p>I tried "WHERE user_id IN $row_interest", but it doesn't seem to work. What could I be doing wrong?</p>
  
  <p>Thanks.</p>