Re: Still need help with miscount
| From: | Chris Lee | Date: | Tue, 18 Dec 2001 16:40:10 +0000 |
| Subject: | Re: Still need help with miscount | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-78105@lists.php.net to get a copy of this message | ||
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
lee@mediawaveonline.com
"Fîk ì?çìsâî" <d@mindbash.com> wrote in message
news:mindbash_3c1cb4100d187@webmail.mindbash.com...
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