I am using the below query to find all of the trails someone has traveled.
I have the trails stored like:
3|trail1, trail6, trail2
The problem is that they were setup as one per field but now we have a multiselect so they have have more then one in a field and they are separated by ', '.
$result3 = mysql_query("SELECT DISTINCT trail FROM cms_activities WHERE user_id = '".$_COOKIE['member_id']."'")
$trails = mysql_num_rows($result3);