[sabret00the]

funnily enough i just changed it to read a bit better with this

PHP Code:

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


and i know all the colums are there so it's just confusing me.

Originally Posted by The Geek

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

you're right the single quotes fixed it, thank you

though now i'm getting

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT user.username, prs_users.userid, user.email
			FROM prs_users
			LEFT JOIN user AS user ON (user.userid = prs_users.userid)
			WHERE prs_users.subscriptions LIKE = '% 1 %' AND prs_users.userid != 0
		
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '% 1 %' AND prs_users.userid != 0' at line 4

mysql error number: 1064

not sure what that means

nevermind the problem was the = <--- thanks again