what's wrong with this query?

[The Geek]

Tough to say, however it would at least read a little better and be easier to troubleshoot written like this:

PHP Code:

$thesubscribed = $DB_site->query(" 
            SELECT p.username, p.userid, p.email 
            FROM prs_users p 
            LEFT JOIN " . TABLE_PREFIX . "user u ON p.userid = u.userid 
            WHERE p.subscriptions LIKE '%$display[pieceid]%' AND u.userid != $getparentinfo[userid] 
        "); 


I dont know if thats right - nor do I know if I got the fields on the right aliases (p for prd_users and u for users).
Hell, this may actually make it harder for you to troubleshoot - I just thought I would trow it in as its the style I would use.

I point to note is that "% $display[pieceid] %" would have given you problems for a number of reasons (in fact, it shouldnt have compiled).

HTH's m8