bis_codex

I created a database with the name 'food-order', on the search bar i can only search for files on one of the table, how can i search for all the items within the database 'food-order' not a specific table <?php //sql query to get category based on search keyword $sql = "SELECT * FROM tl_category AND apartment_rent WHERE title LIKE '%$search%' OR description LIKE '%$search%' OR location LIKE '%$search%'"; // execute the query $res = mysqli_query($conn, $sql); // count rows $count = mysqli_num_rows($res); // check whether category is available or not if($count>0){ // category is available while($row=mysqli_fetch_assoc($res)){ // get the details $id = $row['id']; $title = $row['title']; $price = $row['price']; $description = $row['description']; $location = $row['location']; $image_name = $row['image_name']; ?>