- MySQL (MariaDB) 10.1x
- PHP 5.6
In our app we have a translation context string. This string is build out of an tree.
[url removed, login to view]
The context parts are variable. And are possible one part up to 8 parts (dots).
Each item of the context is stored with its own ID and its parent inside the database.
ID, parent, name
1, 0, parameter
3, 1, names
4, 3, FrontSpalt
In a second table, I have a text to the last part of the context (right part) that is not isHelp=0
ID, parent, text
2,4,”Maß von Kor…..”
I want to build now a SQL query that shows me as a result the whole context with its text from the second table.
This result have to be written as html page with php 5.6
Attached you will find a dump of the two tables. This only contain some sample data.
The database do not contain “WITH” statement so it have to be solved another way.
I expect SQL scripts to run in phpymyadmin frontend.
[url removed, login to view] = “Maß von Korpusvorderkante bis zur Innenkante der F.”
Re-Upload Dump files
27 freelancers are bidding on average $144 for this job
Looking forward to discuss further details about the project Relevant Skills and Experience proven track record on this site Proposed Milestones $222 USD - milestone
Hello, Honorable Hiring Manager, Relevant Skills and Experience I am Expert Web Developer & I have 7+ years of experience. Web Development and Graphics designer Proposed Milestones $155 USD - Project Milestone