I suggest modifying your query like this:
$result = $mysqli->query("SELECT (DATE_FORMAT(date,'%k')) hour,
(DATE_FORMAT(date,'%i')) minute, analog4 rlsolar, analog3 vlsolar FROM
t_data WHERE date(date) = date(date_sub(now(), INTERVAL $wert day)) and
frame = \"frame1\"");
and then inputting your "timeofday" data like this:
$temp[] = array('v' => array((int) $r['hour'], (int) $r['minute'], 0, 0));
On Sunday, July 13, 2014 4:07:20 AM UTC-4, meinolf lutter wrote:
>
>
> i will post the important part´s of my php script
> mybay anyone can write the mistake
>
>
> ## select from sql
> $result = $mysqli->query("SELECT (DATE_FORMAT(date,'%k%i')) date,analog4
> rlsolar ,analog3 vlsolar FROM t_data WHERE date(date) = date( date_sub(
> now( ) , INTERVAL $wert day)) and frame = \"frame1\" ");
>
> ## convert in json format
> array('label' => 'date', 'type' => 'timeofday'),
> $temp[] = array('v' => (string) $r['date']);
>
>
> ## html to call googlechart
> <!--Load the Ajax API-->
> <script type="text/javascript" src="https://www.google.com/jsapi
> "></script>
> <script type="text/javascript" src="
> http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js";></script>
> <script type="text/javascript">
> google.load('visualization', '1', {'packages':['corechart']});
> google.setOnLoadCallback(drawChart);
> function drawChart() {
> var data = new google.visualization.DataTable(<?=$jsonTable?>);
>
> var options = {
> title: 'Restsauerstoff / Leistung',
> is3D: 'true',
> width: 1400,
> height: 500,
> hAxis: {format: 'HH:mm'}
>
>
>
>
--
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.
For more options, visit https://groups.google.com/d/optout.
