Can I use MySQL joins with DW Anything?

Дата добавления:
01.04.2016
Последнее изменение:
01.04.2016
Хиты:
2325
Рейтинг:
 
Голосовать:
Хорошо - Плохо

Ответ

Yes, you can use MySQL joins to retreive the results from multiple related tables.

Within an SQL query, set the join as normal:

SELECT user.username, contact.address FROM #__users AS user LEFT JOIN #__contact_details AS contact ON user.id = contact.user_id

In your Template, in DW Anything module settings, use the column names:

User: {usersname}<br />
Address: {address}

Note that you must not include the table name from SELECT clause in your template tags, just the column name.

Категория

Добавить комментарий


Защитный код
Обновить

SEO by Artio