3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 5   (RSS)

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?

Cheers,



Tim Forrest

Toledoh Enterprises

www.toledoh.com.au

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,

Daniel
PHP Programmer
interactivetools.com