help array problem

[Anon]

Please help im trying to count from a database and add it to an array. This is the code I have come up with as you can guess it does not work

$result = mysql_query("select count(*) as count from wars_completed where c_wld='1'");
while($a_row = mysql_fetch_row($result))
{
$data[] = array
(
"won"=>$a_row[$c_wld],
);
}
foreach ($data as $key=>$val)
{
print "$key = $val<br>";
}

I get this from the output
0 = Array

I now the count works because I can echo the result from the quirie like this and get data

$result=mysql_query("select count(*) as count from wars_completed where c_wld='1'");
$won = mysql_result($result,0,"count");

echo "$won";

Please help if you can

[Anon]

not sure if this is what you want:

$data = array();

$result = mysql_query("select count(*) as count from wars_completed where c_wld='1'");
while($a_row = mysql_fetch_row($result)) {
$data[]=("won"=>$a_row[$c_wld]);
}

if that doesn't get you where you want to be, maybe you can be more specific with the question...

[Anon]

Thanks for your help. I have posted a meassage like this several times but with no response. Ill explaing again if you can help please

First I have a database with a field (c_wld) contains numbers from 1 to 3.

I want to count the numbers then put them into a array so it would end up looking like this

$data = array(
"won"=>10,
"drawn"=>2,
"lost"=>4);

I tried yours but it gives me an error on this line
$data[]=("won"=>$a_row[$c_wld]);

Please help if you can ive been stuck on this one for over a day. :-(

Lee

[Anon]

ok, I think I understand the problem. I have a link and some suggested code. First this link:

http://www.mysql.com/doc/C/o/Counting_rows.html

second, based on the info in the manual (see link above), I come up with:

// different sql statement than your previous
$sql="SELECT wld_col_name, COUNT(*) FROM table_name GROUP BY wld_col_name";
$result = mysql_query($sql);

// declare the array
data = array();

// loop through the result and throw the
// values in to an associative array
while($a_row = mysql_fetch_row($result)) {
$wld=$a_row['wld_col_name'];
$count=$a_row['COUNT'];
data[]=array($wld=>$count);
}

I may have some of it wrong, but it should give you a head start. That link should help too. Good luck and let me know if it works.

[Anon]

Craig thanks for your help. !! but Its still not working here is my full code with a small bit of code testeing the array

$data = array();

$sql="SELECT c_wld, COUNT(*) FROM wars_completed GROUP BY c_wld"; 
$result2 = mysql_query($sql);
// loop through the result and throw the 
// values in to an associative array 
while($row = mysql_fetch_row($result2)) { 
$wld=$row['c_wld']; 
$count=$row['COUNT']; 
$data[] = array("won"=>$count); 
} 

// code to test $data //

foreach ($data as $key=>$val)
{
print "$key = $val<br>";
}

but this is the output
0 = Array
1 = Array
2 = Array

it should say won=2

??

Lee

[Anon]

ok - try this: the line:

$data[] += array($wld=>$count);

is correct I think - leave it like that.

$sql="SELECT c_wld, COUNT(*) FROM wars_completed GROUP BY c_wld";
$result2 = mysql_query($sql);
// loop through the result and throw the
// values in to an associative array
while($row = mysql_fetch_row($result2)) {
$wld=$row['c_wld'];
$count=$row['COUNT'];
$data[] += array($wld=>$count);
}

// code to test $data //

foreach ($data as $key=>$val)
{
print "$key = $val";
}

[Anon]

Comes up with

Fatal error: Unsupported operand

with that line

Lee

[Anon]

oops. try:

$sql="SELECT c_wld, COUNT(*) FROM wars_completed GROUP BY c_wld";
$result2 = mysql_query($sql);
// loop through the result and throw the
// values in to an associative array
while($row = mysql_fetch_row($result2)) {
$wld=$row['c_wld'];
$count=$row['COUNT'];
$data+=array($wld=>$count);
}

// code to test $data //

foreach ($data as $key=>$val)
{
print "$key = $val";
}