The same response for the second table

Question

i am having a problem with my code. I am having the same response for my second table. While in the first one it goes to the next column.

PHP

$sql =  "SELECT * from schedule s, matches m GROUP BY s.id";
 $con = mysqli_connect($server_name,$mysql_user,$mysql_pass,$db_name); 
 $result = mysqli_query($con,$sql);


 $response = array();


while($row=mysqli_fetch_array($result))

{
array_push($response, array("start"=>$row[4],"end"=>$row[5],"venue"=>$row[6], "teamone"=>$row[8], "teamtwo"=>$row[9], 
"s_name"=>$row[17]));

}

echo json_encode (array("schedule_response"=>$response));




mysqli_close($con);
?>

Here is the response i am getting. As you can see the teamone, teamtwo and s_name are all the same. It does not get the value of the second column.

{"schedule_response":[
{"start":"2016-11-23 00:00:00","end":"2016-11-24 00:00:00","venue":"bbbb",
 "teamone":"aaa","teamtwo":"hehe","s_name":"sssss"},
{"start":"2016-11-22 00:00:00","end":"2016-11-23 00:00:00","venue":"aaaaaaa",
"teamone":"aaa","teamtwo":"hehe","s_name":"sssss"}]}

Schedule table

Matches Table

Answer 1

You can define the m_id in query

$sql =  "SELECT * from schedule as s, matches as m where s.m_id = m.m_id GROUP BY s.id";