[kall]

Originally Posted by MarcoH64

In PHP the correct query should be:

PHP Code:

 $getusers = $DB_site->query(" 
SELECT user.userid,username 
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "subscriptionlog as subscriptionlog ON (subscriptionlog.userid = user.userid) 
WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10 
"); 


PS I always use a table prefix on my testsite, tou avoid this kind of problems.

That looks so much like the fix I posted a few lines up, I can't even tell what's different.

But your point is well made. Table Prefixes always end up biting me in the ass.