I'm trying to create a checkbox TV that lists values from a text TV. I don't know MYSQL syntax and hope for a little guidance.
The TV holding the text values is "imageTags", it has ID "15" in the "modx_site_tmplvar_contentvalues" table and the values themselves are in the field "value".
Here's the statement I wrote: @SELECT value FROM modx_site_tmplvar_contentvalues WHERE id='15'.
It's modelled from an example found here:
http://wiki.modxcms.com/index.php/Template_Variable_Drop_Down_Menu
What'd I'd like to do with this is display Ditto lists of images on resources that include the values, filtered via the checkbox selection(s).
Any help with the above statement would be greatly appreciated.