A Database Error Occurred
Error Number: 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 personnel.sort ASC' at line 10
SELECT personnel.personnel_id, personnel.first_name, personnel.last_name, personnel.tel, personnel.email, personnel.photo, personnel.title, personnel.visible, personnel.position, personnel.personnel_info, personnel.centre_id, centre.centre_name, centre.centre_address, centre.email as centre_email, centre.phone FROM personnel INNER JOIN centre ON centre.centre_id = personnel.centre_id WHERE centre.centre_id = ORDER BY personnel.sort ASC