Hello everyone.
i'm having trouble adding an extra query to the page "com_osproperty/templates/default/listing.html.tpl.php"
i need to show an extra info to the property preview (i mean this page yourwebiste/index.php?option=com_osproperty&view=ltype&type_id=&category_id=12&country_id=92&company_id=&Itemid=172) and the problem is that query gives results only once, then all the other properties are not shown.
I've executed all queries in phpmyadmin and they all work (of course if WHERE clause is verified), i don't understand why the code inside page doesn't work.
here it is the code i added
Code:
$db = JFactory::getDbo();
$query = "SELECT `field_option` FROM `#__osrs_extra_field_options` AS tab1 INNER JOIN `#__osrs_property_field_opt_value` AS tab2 ON tab1.id = tab2.oid
WHERE (tab2.fid = 114 OR tab2.fid = 115) AND tab2.pid = '".$row->id."'
GROUP BY tab2.fid;";
$db->setQuery($query); //prepara la query da eseguire
$db->query(); //esegue la query
$count = $db->getNumRows();
$rows = $db->loadAssocList();
if($count > 0)
{
$i = 0;
echo "<span> <img src='http://www.unicasa24.it/components/com_osproperty/images/assets/bathroom.gif' width='25' class='png' />".$rows[$i]['field_option']."</span>";
echo "<span> <img src='http://www.unicasa24.it/components/com_osproperty/images/assets/bedrooms.gif' width='25' class='png'/>".$rows[$i+1]['field_option']."</span>";
}
}
what i see is that the $row->id has null value from the second element in the result's list. So only the first in the list is shown.
am i doing something wrong? am i editing the right page?
i am attaching the file i've edited (see lines 116-145).
thank you for your help
