SELECT `expiry_date` FROM `mytable_cbsubs_subscriptions` WHERE `user_id` = [user_id]
Please Log in to join the conversation.
SELECT DATE_FORMAT( `expiry_date`, '%d %b %Y' ) FROM `#__cbsubs_subscriptions` WHERE `user_id` = '[user_id]'
Please Log in to join the conversation.
Such a substitution doesn't exist, not sure where you obtained such a thing.
Please Log in to join the conversation.
I wish that worked as it'd provide some interesting combinations and results. Maybe something to consider for the future.I simply tried to make a mix using different example published on your tutorial..
Please Log in to join the conversation.