Mark_
Member
Thanks Jon, but it seems there is a syntax error now. This is what I get when testing:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM xf_user AS user JOIN xf_user_profile AS user_profile ON user.user_id=us' at line 5 - library/Zend/Db/Statement/Mysqli.php:77