[Marco van Herwaarden]

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.emailFROM prs_users pLEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = p.userid)WHERE p.subscriptions LIKE '%" . $display[pieceid] . "%' AND p.userid != '" . $getparentinfo[userid] . "'");[/SQL]

Most valid would be using also $display['pieceid'] instead of $display[pieceid]. And depending on the column type and where that value is coming from, maybe also measurements to avoid injections, and amybe more but that is difficult to tell based on the info we have.


ohh and yes like mentioned before, TABLE_PREFIX on all tables.