I came across something really very strange, while tinkering with the contacts form I entered this;
- Code: Select all
$sql = "SELECT user_id, username, user_email, user_level
FROM " . PHPBB_USERS . "
WHERE user_level > 0
ORDER BY user_level";
Which worked fine on my local dev server, however when I uploaded the file to my forum it complained with;
- Code: Select all
SQL Error : 1146 Table 'PHPBB_USERS' doesn't exist
At which point I changed it to;
- Code: Select all
$sql = "SELECT user_id, username, user_email, user_level
FROM " . USERS_TABLE . "
WHERE user_level > 0
ORDER BY user_level";
And it then worked as expected, however, I just don't get why it works locally after all 'PHPBB_USERS' is or shouldn't be defined... and no I don't know why I put 'PHPBB_USERS' instead of 'USERS_TABLE'...
