I have worked this over in my head over the holidays and still haven´t got a
solution. Can anyone help?
I have a MySql table populated with numerical values from 0 to 10 in five
different fields. I need a function that counts all occurances of each
value, ie: 1: 12, 2: 3, 4: 74 etc...
I have worked with this code:
$num_vals = array ();
for ($i=0; $i<10; $i++)
{
$shot_count = "SELECT COUNT(*) FROM statistik WHERE shooter='$shooter_login'
AND ((shot_one = '$i') OR
(shot_two = '$i') OR (shot_three = '$i') OR
(shot_four = '$i') OR (shot_five = '$i'))";
$result = mysql_query($shot_count);
$num_vals[$i] = mysql_fetch_array($result);
}
The code works...but returns the wrong results. If i count from the database
manually there is always some occurances missing.
So, today i tried to count the values from an array instead:
$shotcount = "SELECT shot_one, shot_two, shot_three, shot_four, shot_five
FROM statistik WHERE shooter='$shooter_login'";
$results = mysql_query($shotcount);
$bam = mysql_fetch_array($results);
$count = array_count_values ($bam);
while (list($key,$value) = each($count)) {
echo "$key : $value<br>";
}
But this works even worse...it seems to stop populating the array (or
counting the values) after only a couple of rows from the db. The result
looks like:
3 : 4
5 : 2
7 : 2
9 : 2
And there should be alot more of those keys...and a couple of keys more as
well...
I would appreciate any help on this guys. I am soooo stuck :(
# Daniel Alsén | www.mindbash.com #
# [EMAIL PROTECTED] | +46 704 86 14 92 #
# ICQ: 63006462 | +46 8 694 82 22 #
# PGP: http://www.mindbash.com/pgp/ #
--
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]
