javascript - Highcharts accessing all records from database -

javascript - Highcharts accessing all records from database -

i want access records database , populate highchart. code giving me 1 record. want access records member_group. query should changed. tried alot didn't got success.

php code :

$query="select `group`.`name`, count(`member`.`member_name`) total `group`, `member`, `member_group` `member_group`.`group_id` = `group`.`id` , `member_group`.`member_id` = `member`.`id` grouping `group`.`name`"; $result=mysqli_query($connection,$query); $name=""; $series=""; while($row = mysqli_fetch_array($result)) { $name.="'".$row['name']."', "; $series.=$row['total'].","; }

to retrieve members, modify query :

$query="select `member`.`member_name`, `group`.`name`, `group`, `member`, `member_group` `member_group`.`group_id` = `group`.`id`;

javascript php mysql highcharts