[:en]SQL: Copy from another table[:]

[:en]Copy from another table and Partial match string:

connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

// Change character set to utf8
mysqli_set_charset($conn,"utf8");

// Change Time Zone
date_default_timezone_set("Asia/Hong_Kong");



$FirstName = date("Y-m-d");
$LastName = date("h:i:sa");
$Street = $_GET['Street'];
$City = $_GET['City'];
$State = $_GET['State'];


$sql = "INSERT INTO absence (B,C,D,E,F)
        SELECT '$FirstName','$LastName',D,F,G from student
       WHERE  
       (E LIKE '%$dayofweek%' AND K='active')
       OR (F LIKE '%$dayofweek%'AND K='active')";
      
 
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully".$dayofweek;
} else {
    echo "Error: " . $sql . "
" . $conn->error;
}

?>

[:]