1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
$query_chains = "SELECT * FROM chains ORDER BY chainid ASC ";
$result_chains = odbc_exec($connexion, $query_chains);
echo '<ul>';
while($row_chains = odbc_fetch_array($result_chains)){
$chainid = $row_chains['ChainId'];
$query_sites = "SELECT sites.siteid, sites.name AS sitename, sites.customerid, chains.chainid, chains.name AS chainname FROM sites INNER JOIN sitesinchain ON sitesinchain.siteid = sites.siteid INNER JOIN chains ON chains.chainid = sitesinchain.chainid WHERE chains.chainid = $chainid ORDER BY sites.customerid ASC ";
$result_sites = odbc_exec($connexion, $query_sites);
echo 'CHAINE : ';
echo $row_chains['Name'];
while($row_sites = odbc_fetch_array($result_sites)){
echo '<li>';
echo '<input type="checkbox" name="'.$row_sites['siteid'].'" value="'.$row_sites['siteid'].'" checked="checked" />';
echo $row_sites['customerid'];
echo ' - ';
echo $row_sites['sitename'];
echo '</li>';
}
}
echo '</ul>'; |
Partager