search function and the record is coming from 3 different tables
(category,subcategory,brands) of database
problem is that the data which is save in database are save in seperate condition and in the product page it is save with the relation of id although i get their name and also make the search function for products name but how to make it for category and subcategory
search function and the record is coming from 3 different tables (category,subcategory,brands) of database problem is that the data which is save in database are save in seperate condition and in the product page it is save with the relation of id although i get their name and also make the search function for products name but how to make it for category and subcategory