php - How to combine result sets of a sql query? -
I have 5 checkboxes containing foods like chicken, fruits, vegetables, snacks. I am trying to apply it, when the user selects the checkbox item and clicks submit, then he will search for the restaurant providing the selected items, The table will contain 2 fields: Rest, menu and data are deposited in the table like this restid-> 1, menu-> chicken restid-> 1, menu-> burger restid-> 2, menu-> and; Fridge-> 3, menu-> Chicken My suspicion is that I have a plan to find a restaurant in the table, for each item select a selection statement (like restaurant_table * with the loop where menu = 'menu'; ) How can we add results when we loop through the loop I hope you are menu - menuid, restid, menu restaurant host restaurant - restid, name Php code can be Hope this is useful