[Solved] How can i insert the json data into different mysql tables?

Question

Do the following

foreach($array as $row){
  $query = "INSERT INTO Cities values('".$row['id']."','".$row['city']."','".$row['state']."' )" ;
  $res = mysql_query($query);
 }

Accepted Answer

Do the following

foreach($array as $row){
  $query = "INSERT INTO Cities values('".$row['id']."','".$row['city']."','".$row['state']."' )" ;
  $res = mysql_query($query);
 }