title: SQL INSERT INTO table(a, b , c) VALUES (:a, :b, :c, SELECT ...)
body: <p>So I'm trying to insert 4 values into a table. I'm getting 3 values from POST and the other one I want to get it from another table. This is how I thought about implementing it but it doesn't seem to be working. Any suggestions?</p>
  
  <pre><code>$query = "INSERT INTO topics (subject, data, uid, role) VALUES (:user, :pass, :uid, SELECT role FROM users WHERE uid=:uid) ";
  </code></pre>