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? $t = 6; $shot_counts = "SELECT COUNT(*) FROM statistik WHERE shooter='$shooter_login' && shot_one = '$t' || shooter='$shooter_login' && shot_two = '$t' || shooter='$shooter_login' && shot_three = '$t' || shooter='$shooter_login' && shot_four = '$t' || shooter='$shooter_login' && shot_five = '$t'"; $results = mysql_query($shot_counts); $bam = mysql_fetch_array($results); # Daniel Alsén | www.mindbash.com # # d@mindbash.com | +46 704 86 14 92 # # ICQ: 63006462 | +46 8 694 82 22 # # PGP: http://www.mindbash.com/pgp/ #