0
Undo
Votes
I'm trying to display a list with just the current user's records, using a query with this where clause:
WHERE `families`.`household_head` = '_USER_ID_' OR `families`.`household_secondary_head` = '_USER_ID_'
I've tried all sorts of other syntax here (with ` and ' in or not in) and they either result in just showing the shortcode (i.e. "[artdata id="4"]) or it shows the entire list of entries without any filtering.
The SQL works properly in phpMyAdmin (when I manually substitute a user's ID in place of '_USER_ID_'.
Any ideas what might be going wrong?
(There is painfully little documentation available for this extension)
WHERE `families`.`household_head` = '_USER_ID_' OR `families`.`household_secondary_head` = '_USER_ID_'
I've tried all sorts of other syntax here (with ` and ' in or not in) and they either result in just showing the shortcode (i.e. "[artdata id="4"]) or it shows the entire list of entries without any filtering.
The SQL works properly in phpMyAdmin (when I manually substitute a user's ID in place of '_USER_ID_'.
Any ideas what might be going wrong?
(There is painfully little documentation available for this extension)