just to let u know, the "planta" record in my table is type Varchar(45) and
the "capacidadMW" is type decimal (9,2)
On Wednesday, December 12, 2012 11:03:40 AM UTC-6, Ian Haylock wrote:
>
> thanks for the reply ..
>
> the query im using in phpmyadmin showing 55 records: SELECT planta,
> capacidadMW FROM planta;
>
> the code using to encode using JSon (result is only 14 records):
>
> <?php
>
> include('connect-db.php');
>
> $sth = mysql_query("SELECT planta, capacidadMW FROM planta");
> $rows = array();
> $flag = true;
>
> $table = array();
> $table['cols'] = array(
>
> array('label' => 'planta', 'type' => 'string'),
> array('label' => 'capacidad en MW', 'type' => 'number')
> );
>
> $rows = array();
> while($r = mysql_fetch_assoc($sth)) {
> $temp = array();
> $temp[] = array('v' => (string)$r['planta']);
> $temp[] = array('v' => (int) $r['capacidadMW']);
> $rows[] = array('c' => $temp);
> }
>
> $table['rows'] = $rows;
>
> $jsonTable = json_encode($table);
>
> echo $jsonTable;
> ?>
>
>
> On Wednesday, December 12, 2012 10:55:45 AM UTC-6, asgallant wrote:
>>
>> At a guess, I would say you have an error in the SQL in PHP. If you post
>> your PHP code, I'll take a look at it.
>>
>> On Wednesday, December 12, 2012 11:41:25 AM UTC-5, Ian Haylock wrote:
>>>
>>> Hi asgallant, thank you very much for th taking the time to help others.
>>> i have a question if you dont mind, i followed Diana´s sample and got it to
>>> work, well sort of, i used my onw db and managed to show the graph and
>>> everithing, the only thing is that my mysql query running in phpmyadmin
>>> shows 55 records and my json result shows only 14 records, how is that
>>> possible ???
>>>
>>> On Wednesday, December 12, 2012 12:54:06 AM UTC-6, Chrystopher Medina
>>> wrote:
>>>>
>>>>
>>>> ok im gonna start with the php information. and u know i have another
>>>> problem how i cant charge two pie charts in the same place but each with
>>>> different results.... u know i have two questions and i want to charge the
>>>> results from them. in two pie charts..... because i read that just one
>>>> pie
>>>> chart can be charged in the same place.... i could be mistaken
>>>
>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/fobh9tfeP6oJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
