RE: [PHP] Miscount

27; && shot_two = '$t') || (shooter='$shooter_login' && shot_three = '$t') || (shooter='$shooter_login' && shot_four = '$t') || (shooter='$shooter_login' && shot_five = '$t')"; I am really stuck.

Re: [PHP] Miscount

I do not know if this will solve your problem but you should enclose each logical query segment with parenthesies... $shot_counts = "SELECT COUNT(*) FROM statistik WHERE (shooter='$shooter_login' && shot_one = '$t') || (shooter='$shooter_login' && shot_two = '$t') || (shooter='$shooter_login' &&

[PHP] Miscount

Hi guys, still seem to have some trouble with this code. I solved the earlier issues, with your valuable help. But when i echo the results of the query it gives me the wrong results. I have never encountered a faulty count from mysql earlier. Are there any issues with the query i should consider?