[SOLVED] count total number of elements in a array

[gere06]

<?
include("/home/content/g/e/r/gereb/html/ps3t/config22.php");       

$trophies=mysql_query("SELECT userid,var FROM playertrophy WHERE userid=1 ");
$trophies=count($var);

echo"$trophies";

?>

 

[gere06]

What i want to to do is  count all the elements in the array and get a total so if the array is

 

(1,2,3,4,5,6) i want  to add them up and get 6

 

 

but all it does is give me a 0

[unsider]

like this? Just configure your SQL query to fit the code.

 

<?php
// sizeof function
$value= array(2,5,6,8,9);
echo 'size of array = " .sizeof($value). "'; // Output = 5 
?>

 

[gere06]

all that is doing is giving me a 1

 

 

this is what is in the val{4,2,3,5,6,7,8 } for user id 1

i want to add it up and get a total so in this case i want a 7

 

[unsider]

I apologize I didn't test that piece of code, I just wrote it, rather quickly at that.

 

Here is another method.

 

This is where it came from.

http://us.php.net/count

 

 

<?php
$food = array('cat' => array('orange', 'banana', 'apple'),
              'veggie' => array('carrot', 'collard', 'pea'));

// recursive count
echo count($food, COUNT_RECURSIVE); // output 8

// normal count
echo count($food); // output 2

?>

 

 

May I also see the code you used that gave you the '1' output?

[gere06]

<?
include("/home/content/g/e/r/gereb/html/ps3t/config22.php");       

$tro=mysql_query("SELECT userid,val FROM playertrophy WHERE userid=1");
while(list($userid,$val)=mysql_fetch_row($tro)){



echo count($val);
}

?>

 

what i got now still geting 1

[AndyB]

<?php

include("/home/content/g/e/r/gereb/html/ps3t/config22.php");     

$query = "SELECT userid,var FROM playertrophy WHERE userid=1 ";

$result=mysql_query($query) or die("Error: ". mysql_error. " with query ". $query);

$stuff = mysql_fetch_array($result);

echo count($stuff['var']);

?>

[gere06]

<?php
include("/home/content/g/e/r/gereb/html/ps3t/config22.php");       
$query = "SELECT userid,var FROM playertrophy WHERE userid=1 ";
$result=mysql_query($query) or die("Error: ". mysql_error. " with query ". $query);
$stuff = mysql_fetch_array($result);
echo count($stuff['var']);
?>

 

 

still just gives me a 1

[gere06]

any one got anything

[kenrbnsn]

If the field contains a comma separated list, you need to use the explode() function on it to get an array and then count the elements in that array:

<?php
include("/home/content/g/e/r/gereb/html/ps3t/config22.php");       
$query = "SELECT userid,var FROM playertrophy WHERE userid=1 ";
$result=mysql_query($query) or die("Error: ". mysql_error. " with query ". $query);
$stuff = mysql_fetch_array($result);
echo count(explode(',',$stuff['var']));
?>

 

Ken

 

[gere06]

If the field contains a comma separated list, you need to use the explode() function on it to get an array and then count the elements in that array:

<?php
include("/home/content/g/e/r/gereb/html/ps3t/config22.php");       
$query = "SELECT userid,var FROM playertrophy WHERE userid=1 ";
$result=mysql_query($query) or die("Error: ". mysql_error. " with query ". $query);
$stuff = mysql_fetch_array($result);
echo count(explode(',',$stuff['var']));
?>

 

Ken

 

 

thank you i ben looking all day and could not find a way to get it to work but this worked thanks