need more info buddy. does this query work at the mysql command prompt? show us an example, show us 10 records and accual query being exec and what the returned result is and what you think it should be.
-- Chris Lee [EMAIL PROTECTED] "Fîk ì?çìsâî" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, i still need help with this query: $t = 7; $shot_counts = "SELECT COUNT(*) FROM statistik WHERE shooter='$shooter_login' AND (shot_one = '$t' OR shot_two = '$t' OR shot_three = '$t' OR shot_four = '$t' OR shot_five = '$t')"; It doesn´t return the correct count. I have tried to tweak the syntax around, excluding one or more columns to count etc. But it still gives the wrong count. What´s wrong? - Daniel -- 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]