So I have this php file which works absolutely fine offline. When I take it on the remote server, there's one particular table where the 'INSERT' command does not work. The connection and user privileges seem to be all correct because it works on other tables.
Here's the code:
$addLvl="INSERT into levels (buyer_id, l1_pr, l2_pr, l3_pr, l4_pr, l5_pr, l6_pr, l7_pr) values ('$num_code','$Pcode','$l2_pr','$l3_pr','$l4_pr','$l5_pr','$l6_pr','$l7_pr')";
$runLvl=mysqli_query($con,$addLvl);
the same file worked absolutely fine on a second remote location.