Still need help with miscount
| From: | Daniel Alsén | Date: | Sun, 16 Dec 2001 14:49:41 +0000 |
| Subject: | Still need help with miscount | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-77864@lists.php.net to get a copy of this message | ||
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