albertotactik
Member
Sorry ... I am aware that I am a little heavy and quite limited.What is the point of me writing code for you and saying use [0] if you disregard that and make me have to spend even more time explaining.
{gpexpedient ___ gp_exp_hab} is an SQL CONCAT of three columns using " | " as a separator.
The explode using " | " separates these back into the three parts. [0] is the first of these parts which is gp_hab_tipusinmoble. And this is what we want to test for "habitatge".
It is NOT "returning only the label". The label is ... well ... the label which is displayed regardless of what is returned. It is returning "" because [5] is empty.
I am afraid I have done as much as I can for you with this.
I also tried with [0] ... I thought it was referring to the table ... sorry ...
One last question I want to ask you ... and I do not bother anymore with this topic.
Is it possible to show the value it returns using an "echo" or printf?
I would like to check that it returns the value per screen ...
nothing else...
thanks for continuing to help me