Circuit très classique.
fffffffffffffffffffff
{source}
<!-- You can place html anywhere within the source tags -->
<?php
/*
*/
if (!(defined('_JEXEC') || defined('_VALID_MOS'))) {
die('Direct Access to this location is not allowed.');
}
$database = &JFactory::getDBO();
//echo 'database = '.$database;
$database->setQuery("select * FROM `bcos_f_circuits` where `id`='17';");
$rows = $database->loadObjectList();
foreach ( $rows as $row )
{echo '<span style="color: blue; font-weight: bold;">'.$row->couleur;
echo '<span style="color: red; font-weight: bold;">'.$row->cote.'<br/>';
$im = $row->id_massif;
echo '<span style="color: green; font-weight: bold;"> id_massif = '.$im.'<br/>';
$database->setQuery("select * FROM `bcos_f_massifs` where `id`=$im;");
$massifs = $database->loadObjectList();
foreach ($massifs as $massif)
{echo '<span style="color: black; font-weight: bold;">'.$massif->massif.'<br/>';};
};
?>
{/source}
