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?

Cheers,



Tim Forrest

Toledoh Enterprises

www.toledoh.com.au

By Toledoh - September 5, 2019

Perfect!

Thanks Daniel.

Cheers,



Tim Forrest

Toledoh Enterprises

www.toledoh.com.au