sql - How to make a record belong to all options of a field -
i have database of records called "services", each service has 30 attributes , each service has associated country attribute. problem services offered countries. on front end of database have drop-down menu selects records based on country filter. how able include service offered countries without needing duplicate record service , replacing country name.
p.s. interested in actual implementation, using drupal nodes represent each service , view exposed filters select country. if have sql work can too.
your where
clause follow pattern
where (counrtyid = passedvariable or passedvariable = 'all')
Comments
Post a Comment