Hello,
I have developed a dashboard on my local computer using Xampp, PHP and MySql. Everything works great. But, when I upload it to my server I get the following error:
"Data column(s) for axis #0 cannot be of type string"
Here is the php code in the php file to call data from the MySql database.:
var data = google.visualization.arrayToDataTable([
['Risk', 'Count',],
<?php
WHILE ($row = mysqli_fetch_array($AuditRiskRatingBarResult))
{
echo "['".$row["risk"]."', ".$row["tally"]."],";
}
?>
]);
Again, it works as expected on two computers I have set up using Xampp. Pleas help.