PHP PDO/MySQL query not working properly -

so have website people can report tracks. people can tho they're not member of said website , if they're not members, system assign them random "pseudo member number" (pmn here on) in style of "not_a_member_xxxx".

$query_claimed = "select * claims_archive t20pctid=:t20pctid , member_name=:member_name , member_email=:member_email , (member_number=:member_number or member_number '%not_a_member_%')";  $stmt = $con->prepare($query_claimed); $stmt->bindparam(':t20pctid', $t20pctid); $stmt->bindparam(':member_name', $member_name); $stmt->bindparam(':member_number', $member_number); $stmt->bindparam(':member_email', $member_email); $stmt->execute(); 

in testing period have had songs have been reported same person pseudo-number , member number. problem if make query pmn , song exists same member name , e-mail member number, code insert instead of displaying message in style of "you have claimed song".

but if query member number, display above message if record has reported pmn.

i thought there wrong logic, running above query on phpmyadmin, show record if there matches. have read precedence, in case applies here, , in case there's operator order should know about. doing wrong?

thanks in advance , hope made myself understood (english isn't first or second language).

edit add info: although haven't been able identify specific pattern issue, have identified happens particular record.