php søking i kontakter

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
                        $search = mysqli_real_escape_string($conn, $_POST["search"]);
                        $sql = "SET time_zone = '+01:00'";
                        $conn->query($sql);
                        $sql = "
                        SELECT * FROM (
                        (SELECT datoLagtTil AS datoLagtTil, DATE_FORMAT(datoLagtTil, '%d/%m/%Y %H:%i') AS datoLagtTilFormat, type, id, epost, navn, 'firma' AS source FROM firmaer)
                        UNION ALL
                        (SELECT datoLagtTil AS datoLagtTil, DATE_FORMAT(datoLagtTil, '%d/%m/%Y %H:%i') AS datoLagtTilFormat, type, id, epost, CONCAT(fornavn, ' ', etternavn) navn, 'person' AS source FROM personer)
                        ORDER BY datoLagtTil DESC) as RAW WHERE navn LIKE '%$search%'
                        ";
                        $results = $conn->query($sql);
                        if ($results->num_rows > 0) {
                            while($row = $results->fetch_assoc()) {
                                if ($row["source"] == "person") {
                                    echo "<tr class='table-person'>";
                                    echo "<td>" . $row["navn"] . "</td>";
                                    echo "<td>" . $row["type"] . "</td>";
                                    echo "<td>" . $row["datoLagtTilFormat"] . "</td>";
                                    echo "<td>" . "<a href ='mailto:" . $row["epost"] . "' target='_blank'>" . $row["epost"] . "</a>" . "</td>";
                                    echo "<td>" . "<a href='/endreKontakt.php?id=" . $row["id"] . "&type=" . $row["type"] . "'>Endre</a>" . "</td>";
                                    echo "</tr>";
                                }
                                elseif ($row["source"] == "firma") {
                                    echo "<tr class='table-firma'>";
                                    echo "<td>" . $row["navn"] . "</td>";
                                    echo "<td>" . $row["type"] . "</td>";
                                    echo "<td>" . $row["datoLagtTilFormat"] . "</td>";
                                    echo "<td>" . "<a href ='mailto:" . $row["epost"] . "' target='_blank'>" . $row["epost"] . "</a>" . "</td>";
                                    echo "<td>" . "<a href='/endreKontakt.php?id=" . $row["id"] . "&type=" . $row["type"] . "'>Endre</a>" . "</td>";
                                    echo "</tr>";
                                }
                            }
                        }
                        else {
                            echo "Ingen kontakter funnet.";
                        }
                    }