it worked !!!!!!!!!!!!!!!!!!!! thanks again
On Thursday, March 7, 2013 3:36:41 PM UTC-6, asgallant wrote:
>
> You'll have to debug the output from the database to figure out whether
> the query is wrong or the PHP is wrong. Use var_dump to examine the
> contents of the returned data:
>
> while($r = mysql_fetch_assoc($sth)) {
> /*
> $temp = array();
> $temp[] = array('v' => (string)$r['planta']);
> $temp[] = array('v' => (int) $r['capacidadMW']);
> $temp[] = array('v' => (int) $r['disponibilidadmw']);
> $rows[] = array('c' => $temp);
> */
> var_dump($r);
> echo '<br />';
> }
>
> Open the data source in a browser and examine the contents. You should
> see a bunch of arrays with "planta", "capacidadMW", and "disponibilidadmw"
> keys; check the values in the disponibilidadmw key to see if they match
> your database. If they do, there is a problem with the PHP. If they
> don't, then there is a problem with the SQL.
>
>
> On Thursday, March 7, 2013 4:18:25 PM UTC-5, Ian Haylock wrote:
>
> for some reason is not working for me ... it works fine without adding the
> new column (showing only the capacidadmw data without the new
> disponibilidadmw) but when i add the disponibilidadmw that column gets back
> empty, even though it appears in the column titles, but its value comesback
> as 0 in all... but when i try the same query in phpmyadmin it returns
> values properly fot that column too
>
> this is what i have after adding the new info to the data table:
>
> ************************************************************************************************************
> testing-double-axis.php
>
>
>
>
> ************************************************************************************************************
> On Thursday, March 7, 2013 1:58:37 PM UTC-6, asgallant wrote:
>
> You also need to add it to the list of columns:
>
> $sth = mysql_query("SELECT planta, capacidadMW, disponibilidadmw FROM
> planta");
>
> $table = array();
> $table['cols'] = array(
> array('label' => 'planta', 'type' => 'string'),
> array('label' => 'capacidad en MW', 'type' => 'number'),
> array('label' => 'disponibilidad 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']);
> $temp[] = array('v' => (int) $r['disponibilidadmw']);
> $rows[] = array('c' => $temp);
> }
>
> On Thursday, March 7, 2013 2:41:42 PM UTC-5, Ian Haylock wrote:
>
> so is possible.. great !!! : this is what i have:
>
> ************************************************************************************
> $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;
> ?>
>
> ************************************************************************************
>
> i changed: $sth = mysql_query("SELECT planta, capacidadMW FROM planta");
> ...and now i retrieved one more data (disponibilidadmw) so it looks like
> this now:
>
> $sth = mysql_query("SELECT planta, capacidadMW, disponibilidadmw FROM
> planta");
>
> my question is... wehere to i add that to my data table??? is it as easy
> as to add the line: $temp[] = array('v' => (int) $r['disponibilidadMW']);
> ?? cause is not working for me...
>
> sorry to trouble you for something im sure is basic for you ... and thanks
> again man..
>
>
> On Thursday, March 7, 2013 10:35:15 AM UTC-6, Ian Haylock wrote:
>
> Hi asgallant... i was wondering if you could help me, i have the grapgh
> working fine showing one bar per x axis data, what i need now is to use a
> bar chart to show two or more bars per each x axis data, not stacked but
> side by side like when you group, see (
> https://developers.google.com/chart/interactive/docs/gallery/barchart?hl=es)
> ... can i do it following this same example? if so , how do i retrieve
> and add the other data to the code?
>
>
> On Wednesday, December 12, 2012 3:51:13 PM UTC-6, Ian Haylock wrote:
>
> it worked !!!!!!! cant say thank you enough..... i wish there were more
> people like you.
>
> On Wednesday, December 12, 2012 3:39:22 PM UTC-6, asgallant wrote:
>
> You have a couple of unnecessary lines in your javascript:
>
> alert(typeof(jsonData));
> console.log(jsonData);
>
> The first is what pops up that message. The second is dumping the
> contents of the json to the developers console - this will cause the script
> to bomb in older versions of IE, as they don't have a console object.
> Delete or comment these two lines and you should be fine.
>
> On Wednesday, December 12, 2012 4:24:30 PM UTC-5, Ian Haylock wrote:
>
>
> <https://lh4.googleusercontent.com/-sbGpcUatdqI/UMj1-PVHiqI/AAAAAAAAALM/1muCotW-3_0/s1600/string.png>
> json generated:
>
> {"cols":[{"label":"planta","type":"string"},{"label":"capacidad en
> MW","type":"number"}],"rows":[{"c":[{"v":"Francisco
> Morazan"},{"v":300}]},{"c":[{"v":"Lufussa
> III"},{"v":267.4}]},{"c":[{"v":"Enersa"},{"v":259}]},{"c":[{"v":"EEHSA -
> Mesoamerica"},{"v":102}]},{"c":[{"v":"Elcosa"},{"v":80}]},{"c":[{"v":"Lufussa
> II"},{"v":80}]},{"c":[{"v":"Rio Lindo"},{"v":80}]},{"c":[{"v":"Emce
> Choloma"},{"v":55}]},{"c":[{"v":"Lufussa I"},{"v":40}]},{"c":[{"v":"Enersa
> (excedente de 30
> MW)"},{"v":30}]},{"c":[{"v":"Nacaome"},{"v":30}]},{"c":[{"v":"Ca\u00f1averal"},{"v":29}]},{"c":[{"v":"La
>
> Ceiba"},{"v":26}]},{"c":[{"v":"La Grecia -
> Celsur"},{"v":25.5}]},{"c":[{"v":"Cahsa - Azucarera
> Hondure\u00f1a"},{"v":25}]},{"c":[{"v":"El
> Nispero"},{"v":22.5}]},{"c":[{"v":"Envasa"},{"v":21}]},{"c":[{"v":"Elcatex"},{"v":21}]},{"c":[{"v":"Chumbagua"},{"v":20}]},{"c":[{"v":"Nacional
>
> de Ingenieros"},{"v":20}]},{"c":[{"v":"La Puerta MEX -
> Hitachi"},{"v":18}]},{"c":[{"v":"Celsur"},{"v":18}]},{"c":[{"v":"La Puerta
> ENEE- General Electric"},{"v":15}]},{"c":[{"v":"CISA - La
> Esperanza"},{"v":12.7}]},{"c":[{"v":"Cuyamapa"},{"v":12.2}]},{"c":[{"v":"Ampac
>
> (American Pacific)"},{"v":10.1}]},{"c":[{"v":"Azunosa ( IHSA
> )"},{"v":10}]},{"c":[{"v":"Geen Valley - Park
> Dale"},{"v":10}]},{"c":[{"v":"AYSA"},{"v":8}]},{"c":[{"v":"Cuyamel"},{"v":8}]},{"c":[{"v":"Tres
>
> Valles"},{"v":7.8}]},{"c":[{"v":"El
> Cisne"},{"v":7}]},{"c":[{"v":"Cortecito"},{"v":6}]},{"c":[{"v":"La
> Gloria"},{"v":5.3}]},{"c":[{"v":"Santa Fe"},{"v":5}]},{"c":[{"v":"Rio
> Blanco"},{"v":5}]},{"c":[{"v":"Coronado"},{"v":4.5}]},{"c":[{"v":"Babilonia"},{"v":4.3}]},{"c":[{"v":"San
>
> Carlos"},{"v":4}]},{"c":[{"v":"Cececapa"},{"v":3.5}]},{"c":[{"v":"El
> Coyolar"},{"v":1.7}]},{"c":[{"v":"Mangungo
> I"},{"v":1.5}]},{"c":[{"v":"Santa Maria del
> Real"},{"v":1.2}]},{"c":[{"v":"Eda"},{"v":1.2}]},{"c":[{"v":"Aceydesa"},{"v":1.1}]},{"c":[{"v":"Yodeco"},{"v":1}]},{"c":[{"v":"Zacapa"},{"v":0.8}]},{"c":[{"v":"Yojoa"},{"v":0.6}
>
> ...
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
