Help with sub query

[MDanz]

      $logged = $_SESSION['logged'];
                
      $construct =  "SELECT child.* 
                     FROM products child 
                     LEFT JOIN products parent on parent.sid=child.sid 
                     WHERE parent.id =
                       (SELECT productid 
                         FROM subscribed 
                         WHERE username='".$logged."') 
                     AND parent.keyword != child.name 
                     ORDER BY child.id DESC";  

 

 

I'm having trouble getting the subquery to work i get the wrong results.  The parent query is fine because i have used it before.  This is my first time using a sub query so bare with me.

 

I want the sub query to get all productids from the table 'subscribed' where username=$logged.

 

This is what i want but in one query, check WHERE clause for differences.

    $construct =  "SELECT child.* 
                   FROM products child 
                   LEFT JOIN products parent on parent.sid=child.sid 
                   WHERE parent.id= 
                     'SUB QUERY RESULT 1' 
                   AND parent.keyword != child.name 
                   ORDER BY child.id DESC"; 
    
    $construct =  "SELECT child.* 
                   FROM products child 
                   LEFT JOIN products parent on parent.sid=child.sid 
                   WHERE parent.id=
                     'SUB QUERY RESULT 2' 
                   AND parent.keyword != child.name 
                   ORDER BY child.id DESC"; 
    
    $construct =  "SELECT child.* 
                   FROM products child 
                   LEFT JOIN products parent on parent.sid=child.sid 
                   WHERE parent.id=
                     'SUB QUERY RESULT 3' 
                   AND parent.keyword != child.name 
                   ORDER BY child.id DESC"; 

 

How do I do this in one query without looping the query.  Do I even need a subquery?

[fenway]

I don't follow.

[Muddy_Funster]

instead of

WHERE parent_id =

use

WHERE parent_id IN