title: MySQL Usernames Listed in ONE Field Inside of a Table To Query Another Table and Return User Results
body: <p>So I am new to PHP and I have been on a roll lately developing a website. My question is this. I have all users listed inside of a field in one table.</p>
  <p>This is a list of one of these fields: admin, user1, user2, user3.</p>
  <p>Now what I need to do is take them users from that ONE field, I am guessing put them into an array and then search each user inside of another table called users and then list the users info such as their rating and bio.</p>
  <p>I reposted this with pictures to help you get an idea of what I am looking to accomplish.</p>
  <p>I am looking to get the users from this table listed inside of that cell
  <a href="https://i.stack.imgur.com/iWEOr.png" rel="nofollow noreferrer">jobs Table</a></p>
  <p>and find them in this table and then list them
  <a href="https://i.stack.imgur.com/dAUQB.png" rel="nofollow noreferrer">users table</a></p>
  <p>Hey I have edited the code in the following way and I am getting an error.</p>
  <pre><code>$jobID = 1;
  $jq = $con-&gt; prepare('SELECT applied_names FROM jobs WHERE jobID=1 LIMIT 1');
  $jq-&gt; execute();
  $jq-&gt; bind_result($usernames);
  $jq-&gt; fetch();
  $jq-&gt; close();
  
  $stm = $con-&gt;prepare(&quot;SELECT username FROM users WHERE username IN (?)&quot;);
  $stm-&gt;execute(array($usernames));
  $result = $stm-&gt;get_result()-&gt;fetch_assoc();
  $stm-&gt;close();
  </code></pre>
  <p>The warning says:</p>
  <blockquote>
  <p>Warning: mysqli_stmt::execute() expects exactly 0 parameters, 1 given on line 14</p>
  </blockquote>