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 ') DESC' at line 1

SELECT p.* FROM relationships r, profiles p WHERE r.member_id='' AND r.approved=1 AND p.profile_id=r.profile_id ORDER BY (p.created_by=) DESC