How to create a search with multiple tables with php and mysqli

[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'];

 

                        ?>

[Barand]

To answer your question I would need to know

• what tables are in the database and
• the structures of those tables.