problem in json/ajax

[Daniel Cipriano]

i have this code

Code:

<script type="text/javascript">
   jQuery(document).ready(function(){
      jQuery("button").click(function(){

         jQuery.ajax({
            url: "chart.php",
            dataType: "json", 
            success: function(json){
               var msg = "valor1: " + json.valor1+ "\n";
               msg += "valor2: " + json.valor2 + "\n";
               alert(msg);
            }
         });
      });
   });
   
   </script>

and a php

PHP Code:

$query = mysql_query("SELECT valor FROM grafico") or die(mysql_error());


$i = 1;
while($row = mysql_fetch_assoc($query)) {
    $arr[] = array("valor{$i}" => $row["valor"]);
    ++$i;
}
echo json_encode($arr); 

the result is something like [{"valor1":"20"},{"valor2":"50"}]

i don't know why the ajax only works without [] like:

{"valor1":"20"},{"valor2":"50"}

what is the problem? and how i can solve that? if i change $arr[] to $arr only show the last value of the table

thanks

[Eric Pascarello]

This is not a JSON object, that is an array.

[{"valor1":"20"},{"valor2":"50"}] 

If you want to pass it back as a JSON object, than:

{ "values" : [{"valor1":"20"},{"valor2":"50"}]  }

Than with the response you just do

json.values to get the array.

Eric

[Daniel Cipriano]

this solve my problem

json[0].valor1

thanks

[Bear Bibeault]

Yeah, you've got to treat the data the way that it is formatted. If an array is returned, you need to treat it like an array.