Related Records with Mulit-select
3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 5, 2019 (RSS)
By Toledoh - September 4, 2019
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?
Tim (toledoh.com.au)
By daniel - September 5, 2019
Hey Tim,
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!
Thanks,
Technical Lead
interactivetools.com