How to combine INSERT with SELECT?

Question

PHP

How to fix this script? I don't understand how to combine them?

if($_POST['message'] != ""){

    $id_client = $_SESSION['id_client'];
    $text = $_POST['message'];
    $type = "2";
    $data = date("Y-m-d H:i:s");
    $status = "0";

    $query = "INSERT INTO messages (id_dialog, text, type, data, status) SELECT
 id_dialog, $text, $type, $data, $status
  FROM dialogs WHERE id_client = '$id_client'";

    $result = db_connection($query);

    exit;
}

The script goes to the server.

Answer 1

before executing the query, execute
and try to duplicate the query in any MySQL client, it will immediately become clear where the error is

Answer 2

There is no logic in the line SELECT id_dialog, $text, $type, $data, $status. You are trying to get a column with a name in a variable, for example $data. Each time it will be different values. It's easy to guess that you don't have a column for every millisecond of time))
It may be more correct to SELECT id_dialog, text, type, data, status - but no one will tell you what table you have, what this script should do, etc.

Answer 3

Write better two separate requests.