Server Environment
- Linux
- MySQL (MariaDB) 10.1x
- PHP 5.6
Solution:
In our app we have a translation context string. This string is build out of an tree.
Like:
[login to view URL]
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.
Like:
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
Like:
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.
As Sample:
[login to view URL] = “Maß von Korpusvorderkante bis zur Innenkante der F.”
Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You!
Relevant Skills and Experience
graphic, html, php, web
Proposed Milestones
$75 USD - 50% to start work
$75 USD - 50% after completing work
Looking forward to discuss further details about the project
Relevant Skills and Experience
proven track record on this site
Proposed Milestones
$222 USD - milestone
Hey there,
If you're looking for excellent development quality and great English communication skills, you've come to the right place.
Relevant Skills and Experience
I am a highly experienced web developer, with 13+ years of professional experience and excellent English communication skills.
I am highly experienced in PHP, MySQL (LAMP), HTML, CSS, JS and jQuery.
Proposed Milestones
$250 USD - default
Would definitely need further details from you on your project.
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
HI,
I would like to work on your sql task.
I think that using WHILE and SELECT TOP 1 we can build a solution
Relevant Skills and Experience
I am .net/php/sql developer
I work from Italy
Proposed Milestones
$111 USD - sql
The input is = ?
The output will be ?
Hello! , my name is Jose, I have plenty of experience with website design, as well as HTML, PHP and WordPress. I would be happy to do this for you.
Relevant Skills and Experience
experience with website design, as well as HTML, PHP and WordPress.
Proposed Milestones
$155 USD - Final delivery