Invalid syntax in query:
SELECT SQL_CALC_FOUND_ROWS audio_group.id AS audio_group_id, audio_group.date_of_call AS audio_group_date_of_call, audio_group.description AS audio_group_description, audio_allowed.audio_group_id AS audio_allowed_audio_group_id, audio_allowed.bk_user_access_level_id AS audio_allowed_bk_user_access_level_id, audio_files.id AS audio_files_id, audio_files.call_title AS audio_files_call_title, audio_files.filename AS audio_files_filename, audio_files.length AS audio_files_length, audio_files.sort_order AS audio_files_sort_order, audio_files.audio_group_id AS audio_files_audio_group_id FROM audio_files INNER JOIN audio_group ON( audio_group.id = audio_files.audio_group_id ) INNER JOIN audio_allowed ON( audio_allowed.audio_group_id = audio_group.id ) WHERE audio_allowed.bk_user_access_level_id = ORDER BY audio_group.date_of_call DESC, audio_files.sort_orderMySql Error (1064):
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 'ORDER BY audio_group.date_of_call DESC, audio_files.sort_order' at line 16
Warning: Invalid syntax in query: SELECT SQL_CALC_FOUND_ROWS audio_group.id AS audio_group_id, audio_group.date_of_call AS audio_group_date_of_call, audio_group.description AS audio_group_description, audio_allowed.audio_group_id AS audio_allowed_audio_group_id, audio_allowed.bk_user_access_level_id AS audio_allowed_bk_user_access_level_id, audio_files.id AS audio_files_id, audio_files.call_title AS audio_files_call_title, audio_files.filename AS audio_files_filename, audio_files.length AS audio_files_length, audio_files.sort_order AS audio_files_sort_order, audio_files.audio_group_id AS audio_files_audio_group_id FROM audio_files INNER JOIN audio_group ON( audio_group.id = audio_files.audio_group_id ) INNER JOIN audio_allowed ON( audio_allowed.audio_group_id = audio_group.id ) WHERE audio_allowed.bk_user_access_level_id = ORDER BY audio_group.date_of_call DESC, audio_files.sort_order . MySql Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version f in /home/www/phpGammaCode/sql/CSqlQuery.php on line 248





