Ok first of all, please forgive my random english (yeah, I'm french).
Then, here is my problem (I already searched, but I didn't found any suitable answer :s) :
I use chronoconnectivity to display some data rows of "myTable" like {id}, {name} etc...
Now, I want to add in the same webpage {someInformations} from "anotherTable" linked by "myTable" on "mytable".{id} = "anotherTable".{id}.
So, in the <body> I just put the following php code : <?php sql = "SELECT someInformations FROM anotherTable WHERE id = " . '{id}';?>
But an error occured and I can't display {someInformations} because '{id}' in the where clause doesn't take the value from the result of chronoconnectivity (when my sql request is launched, {id} = nothing)
Any idea to show me a way to display the value of {someInformations} ?
I tried to put an "INNER JOIN" in the where clause of chronoconectivity, I also tried to select the whole data by using a data view... I feel depressed😀
Thanks in advance o/
Then, here is my problem (I already searched, but I didn't found any suitable answer :s) :
I use chronoconnectivity to display some data rows of "myTable" like {id}, {name} etc...
Now, I want to add in the same webpage {someInformations} from "anotherTable" linked by "myTable" on "mytable".{id} = "anotherTable".{id}.
So, in the <body> I just put the following php code : <?php sql = "SELECT someInformations FROM anotherTable WHERE id = " . '{id}';?>
But an error occured and I can't display {someInformations} because '{id}' in the where clause doesn't take the value from the result of chronoconnectivity (when my sql request is launched, {id} = nothing)
Any idea to show me a way to display the value of {someInformations} ?
I tried to put an "INNER JOIN" in the where clause of chronoconectivity, I also tried to select the whole data by using a data view... I feel depressed😀
Thanks in advance o/