= (CURRENT_DATE - INTERVAL 24 HOUR)) AND (SCODE = 'RPI4-A') ) AS X, (SELECT @curRow := 0) r GROUP BY tdate, tday, thour ) as A ORDER BY row_number DESC LIMIT 24 ) AS B ORDER BY row_number ASC"; $result = mysqli_query($conn,$sql); //$json_array = array(); while($row = mysqli_fetch_assoc($result)) { $jsonlabel[] = $row["labels"]; $jsontemp[] = (float)$row["avgTemp"]; } $Series[]=$jsontemp; $Series[]=$jsonhumidity; /* echo "

";
	print_r ($jsontemp);
	print_r ($jsonhumidity);
	echo "

"; */ $myObj->labels = $jsonlabel; $myObj->series = $Series; echo json_encode($myObj); ?>