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 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
conference call schedule

Contact Us

Phone:

BK Advisor Program
Barbara Dorsey: 317-913-4023

Complete the form below to contact a member of our staff

First Name:
State:
Email:
Confirm Email:
Question:
We value your privacy. Please see our privacy policy for more information