RE: [PHP] Miscount
| From: | Daniel Alsén | Date: | Fri, 14 Dec 2001 23:55:32 +0000 |
| Subject: | RE: [PHP] Miscount | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-77793@lists.php.net to get a copy of this message | ||
Nope,
that didn´t help. I am baffled here.
One more interesting thing is that these two queries deliver different
results.
$num_vals = array ();
for ($i=0; $i<10; $i++)
{
$shot_count = "SELECT COUNT(*) FROM statistik WHERE
(shooter='$shooter_login' && shot_one = '$i') ||
(shooter='$shooter_login' && shot_two = '$i') ||
(shooter='$shooter_login' && shot_three = '$i') ||
(shooter='$shooter_login'
&& shot_four = '$i') || (shooter='$shooter_login' && shot_five =
'$i')";
$result = mysql_query($shot_count);
$num_vals[$i] = mysql_fetch_array($result);
}
$t = 7;
$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')";
I am really stuck. Any suggestions?
- Daniel
> -----Original Message-----
> From: Kevin Stone [mailto:kevin@helpelf.com]
> Sent: den 14 december 2001 23:53
> To: Daniel Alsén; PHP
> Subject: Re: [PHP] Miscount
>
>
> I do not know if this will solve your problem but you should enclose each
> logical query segment with parenthesies...