× Custom Tables Joomla Extension

Support Forum

SQL-Query-Field?

  • Breitenbach
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 months 3 weeks ago #49 by Breitenbach
SQL-Query-Field? was created by Breitenbach
I have created a table with member data. The table contains name, address, email, membership, birthday, etc.

Now I would like to display the age and anniversaries (5, 10, 15 ... years). However, find no way to do it.

I miss a field for SQL queries like in CommunityBuilder. I use this query there:
SELECT 
	CASE WHEN MOD(YEAR(NOW()) - YEAR(cb_join),5) = '0' THEN CONCAT(YEAR(NOW()) - YEAR(cb_join), ' Jahre')  ELSE "" END
    FROM #__comprofiler
WHERE user_id = [user_id]

Or is it maybe possible with a PHP script of the Pro version?

Please Log in or Create an account to join the conversation.

Time to create page: 0.193 seconds
Powered by Kunena Forum

JoomlaBoat.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters
the trademark holder in the United States and other countries.