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 'BRIEN%' AND `firstname` like '%DENYSE%' ) order by `position` asc' at line 1

SQL:
select * from `webberz_results` where `rid`='1307' and ( `id`<>'' AND `surname` like '%DAVID-O'BRIEN%' AND `firstname` like '%DENYSE%' ) order by `position` asc