Welcome, Guest
Please Login or Register.    Lost Password?
Kunena
Table JX
Suggestions

Pre-purchase question
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottomPage: 1
TOPIC: Pre-purchase question
#615
Pre-purchase question 2 Months, 1 Week ago Karma: 0
I have two tables in my joomla database with data that I wish to present in a joomla article. One table has 3 text fields i need (and an id field in common with the other table), and another table has one data field that I need.

Firstly, can I link 2 tables in Table JX?

Secondly, the data field in the second table is in comma delimited form. I need each data element in the comma delimited field separated into its own column. Is that possible?

Thanks in advance.
4ZFood
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#619
Re:Pre-purchase question 2 Months, 1 Week ago Karma: 1
Hi,

Firstly, can I link 2 tables in Table JX?
Not yet.

Secondly, the data field in the second table is in comma delimited form. I need each data element in the comma delimited field separated into its own column. Is that possible?

This is possible with SQL. You can create View and display view with Table JX. If you need help, send us mail with details.

Example:
Code:
CREATE VIEW Something AS
SELECT substring_index(field,', ', 2), substring_index(field,', ', -2)
FROM Table



Best regards,
Viljem
viljem
Admin
Posts: 153
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Kunena
Table JX
Suggestions
Powered by Kunenaget the latest posts directly to your desktop
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting