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:[EMAIL PROTECTED]]
> 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...


-- 
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]

Reply via email to