[Colin F]

Originally Posted by Dark Visor

The best and most valid way to write this query would be:

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

I like to have "FROM prs_users AS p", but it's not as if it would make a difference.