PHP将数据从一个表插入另一个表

Question

<?php
$con=mysqli_connect("localhost","usr","pwd","db");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con, "SELECT id, Name, email FROM users WHERE status='ACTIVE'");
while($row = mysqli_fetch_array($result)){
//  echo $row['Name']. " - ". $row['email'];
//  echo "<br />";
$userid = $row['id'];
$username = $row['Name'];
$email = $row['email'];
mysqli_query($con, "INSERT INTO other_user (user_id, username, email)
VALUES ($userid, $username, $email)");
}
mysqli_close($con);
?>

i have the above code i am trying to insert data from one table to another The above code do not returning any error but it do not puts any data to second table "other_user"

Answer 1

There is an error in INSERT query - you have to enclose strings in quotes, like this:

"INSERT INTO other_user (user_id, username, email) VALUES ($userid, '$username', '$email')"