Arrays

[sandy1028]

$graphValues=array();

//Some code

$qry1=mysql_query($qry);

while($qry2=mysql_fetch_array($qry1)){

$graphValues[] =$qry2[0];

 

How to store the values of $qry2[0] into the $graphValues

 

The values should be stored in $graphValues=array(1,34,564,763,6754.............)

 

I am not able to store the values into $graphValues

 

 

 

 

[teng84]

do this first for checking purpose

print_r(mysql_fetch_array($qry1));

 

and post the result

[sandy1028]

The result is like this

 

Array ( [0] => 0.01248649 [avg(bw_util)] => 0.01248649 )

[sandy1028]

Array ( [0] => 0.01248649 [avg(bw_util)] => 0.01248649 ) 

[teng84]

may we see your query?

[sandy1028]

select avg(bw_util) from `tablename` where `fieldname` <  now() and `fieldname` > date_sub(now(),interval 1 day) group by `fieldname`

 

[teng84]

i guess fetch assoc is what you need

 

$qry="select avg(bw_util) as average_list from `tablename` where `fieldname` <  now() and `fieldname` > date_sub(now(),interval 1 day) group by fieldname" ;

$qry1=mysql_query($qry);

print_r(mysql_fetch_assoc($qry1));

 

so you have like

$result = mysql_fetch_assoc($qry1);

[sandy1028]

Array ( [avg(bw_util)] => 0.02123514 )

 

The output is like this.

 

I just want the values in $qry2[0] as an array.

 

How to push the values in $qry2[0] to $graphValues.