Address fields in array for custom list

wallyhowe 08 Apr, 2014
Hi
In order to get two listings on a page i am using a CC4 listing followed by a cc5 listing called via the plugin.
The cc5 listing is (my attempt at) an upgrade from a working cc4 listing.
The change in syntax (moving to jquery I believe) has eluded me so far.
In cc4, in order to address a field from the returned query and use it within php code I used;
$myvariable= $row['model']['field'];
What is the equivalent for CC5?

I am also struggling with a second table in the listing.
In CC4 I had a join rule of:
model1.field1 = model2.field2 in the Join box.
I can't get this to take effect at all. How do i write this condition for CC5 and which box in the model table do I put it in?
Any help with these fundamentals much appreciated.
Wally
Max_admin 09 Apr, 2014
Hi Wally,

#1- In custom listing the same format should work $row["model"]["field"]
#2- There is a join conditions box, but it should return an array:
<?php
return array("model1.field1 = model2.field2");


Please test carefully and enable the debug and check the generated SQL for any issues.

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
wallyhowe 11 Apr, 2014
Hi Max
#1:Yes, works fine. I must have had something else wrong.
#2: Have read the tutorial but not got around to trying it as I got away with a single table.

Thanks for the tutorial though, very valuable.

Wally
This topic is locked and no more replies can be posted.