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 'ANDRE%' ) order by `position` asc' at line 1

SQL:
select * from `webberz_results` where `rid`='1000' and ( `id`<>'' AND `surname` like '%FRASER%' AND `firstname` like '%D'ANDRE%' ) order by `position` asc