Related Records with Mulit-select
I've added a related records field in a section that is looking for matching wigs. The MySQL is not displaying any results, but the more link is - I'm guessing because the related field is a pillbox (multi value).
MySQL Where: wigsNum='<?php echo mysql_escape(@$RECORD['num']) ?>'
More Search Link: wigsNum_match=<?php echo htmlencode(@$RECORD['num']) ?>
I've tried changing the "=" to LIKE or CONTAINS etc. Any thoughts?
Multi-value fields are stored separated by tabs (\t), so using "LIKE" and some wildcard symbols (%) you should be able to do something like this:
wigsNum LIKE "%\t<?php echo mysql_escape(@$RECORD['num']) ?>\t%"
Let me know if that does the trick!