PHP mysql from DB

How to make the search take place in two columns?

<?php include '../connection.php'; $conn = new mysqli($servername, $username, $password, $dbname); mysql_select_db("questions"); $strSQL = "SELECT * FROM films"; $rs = mysql_query($strSQL); ?> Введите ключевое слово или текст. <form action="" method="GET" name="form"> <input name="q" type="text"> <input type="submit" value="Отправить"> </form> <?php $search_slovo = $_GET['q']; if(isset($search_slovo)){ if(empty($search_slovo)) {exit ("Вы не ввели данные");}} echo " Вы искали: $search_slovo"; if ((isset($search_slovo))) { $search_name= mysqli_query($conn, "SELECT `name` FROM `films` WHERE `name` LIKE '%$search_slovo%' "); if (mysqli_num_rows($conn, $search_name) != 0) { while ($row = mysqli_fetch_assoc($search_name)) { echo "Результаты поиска:" . $row['name']; } } else { echo " Ничего не найдено"; } } else { echo "Введен пустой запрос"; } ?> 

But it doesn't work that way.

 <?php include '../connection.php'; $conn = new mysqli($servername, $username, $password, $dbname); mysql_select_db("questions"); $strSQL = "SELECT * FROM films"; $rs = mysql_query($strSQL); ?> Введите ключевое слово или текст. <form action="" method="GET" name="form"> <input name="q" type="text"> <input type="submit" value="Отправить"> </form> <?php $search_slovo = $_GET['q']; if(isset($search_slovo)){ if(empty($search_slovo)) {exit ("Вы не ввели данные");}} echo " Вы искали: $search_slovo"; if ((isset($search_slovo))) { $search_name= mysqli_query($conn, "SELECT `name`,`year` FROM `films` WHERE `name`,`year` LIKE '%$search_slovo%' "); if (mysqli_num_rows($conn, $search_name) != 0) { while ($row = mysqli_fetch_assoc($search_name)) { echo "Результаты поиска:" . $row['name']; } } else { echo " Ничего не найдено"; } } else { echo "Введен пустой запрос"; } ?>