Do the following
foreach($array as $row){
$query = "INSERT INTO Cities values('".$row['id']."','".$row['city']."','".$row['state']."' )" ;
$res = mysql_query($query);
}
solved How can i insert the json data into different mysql tables?
Do the following
foreach($array as $row){
$query = "INSERT INTO Cities values('".$row['id']."','".$row['city']."','".$row['state']."' )" ;
$res = mysql_query($query);
}
solved How can i insert the json data into different mysql tables?