$problem = Array_sum($wierdness)

[snakk]

If I define an array:
$pop = array(0,0,1,1,2,2,3,3,2,2,1,1,0,0);
and use array_sum($pop) I get a correct answer: (in this case, 18).

However if I use a MySQL table with defined ints (all sizes = 4) and the 1st column is the primary key (char(20)) and then use mysql_fetch_array:

$sql = "select * from table where p_key = \"$p_key\"";
$popfull = mysql_fetch_array(mysql_db_query("database", $sql));

then use array_slice to strip out the primary key data:

$pop = array_slice($popfull,1);

the array_sum function returns wrong answers.

The above is an example; my real problem has 100 ints (all size = 4). Array_sum on all elements returns twice the expected value (222 instead of 111), but this could be coincidence. Array_sum on an array_sliced subset returns values plucked from the air it seems.

A for-loop adding $pop[$index] works.
So where am I going wrong?

[Anon]

That is because mysql_fetch_array() returns both the numeric index and the fieldname index in the array. i.e.

// prints data in field 1 which is the 'name' field
echo $row[1];

// prints the data in the name field which is also field 1
echo $row['name'];

Take a look at mysql_fetch_aray in the manual and the optional params you can pass to only get one set of the data (or just call mysql_fetch_assoc() instead).

G'luck,

Jack

[snakk]

Been in programming long enough to know it was MY fault - and yes, they're always obvious once pointed out. Doh!

Many thanks for your help.

[kiwi_uk]

That solved my problem too dudes. Thanks.