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' && shot_three = '$t') || (shooter='$shooter_login' && shot_four = '$t') || (shooter='$shooter_login' && shot_five = '$t')"; > 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 # > # [EMAIL PROTECTED] | +46 704 86 14 92 # > # ICQ: 63006462 | +46 8 694 82 22 # > # PGP: http://www.mindbash.com/pgp/ # > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
