[sabret00the]

even when i use the echo to read it via the top of the page it stops at the table prefix.

[sql] SELECT username, userid, 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 userid != $getparentinfo[userid]
[/sql]

and i'm calling it like this

PHP Code:

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