Posted on 2011-09-05
Hey guys, i have a database and a coloum called foodtypes which stores all my food types for a restaurant.
hey is a sample layout
id Restaurant_Name Food_Types
1 ritz Buffet,Chinese,Indian
now in my website i have a checklistbox which the user select the food types :
here is a list of my checkboxlist
now if the user selects one of the following i want to do a search?
the hard part is that my coloum where my foodtypes is stored for a reastarant has "," to seperate the food types :( .
how would i go about to search in a query?