1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| <?php
$query_ban = $db->query ("SELECT liens.numero AS ban_numero,
liens.site,
liens.designation,
liens.code as code,
sites.pr,
sites.numero,
clients.email,
sites.url
FROM liens
INNER JOIN clients ON clients.numero=liens.client
LEFT JOIN sites ON sites.numero = liens.site
WHERE liens.site = '$id_site'
ORDER BY ban_numero
" );
// voici ma selecte
<select name='mabannier' id='mabannier' required='required' >
<?php
echo " <option value='' selected='selected' >Choisir une Bannier</option>";
while (($donnees = $query_ban->fetch()) == TRUE)
{
list($numero,$site,$designation,$code,$monsite_pr,$monsite,$email_web1,$site_web1)=$donnees;
echo '<option value="' .$numero. '"> '.$designation.' </option>';
}
?>
</select>
<input type='hidden' value='testing' id='HiddenInput' enableviewstate="true"/>
<?php
$query="SELECT liens.numero AS ban_numero,
liens.designation,
liens.code as code,
liens.site
FROM liens
WHERE liens.site = '$id_site'";
if (($res = $db->query($query)) !== FALSE)
{
while (($data = $res->fetch()) !== FALSE)
{
list($numero,$designation,$code)=$data;
echo '<div id="' .$numero. '" class="ban" >'.$code.'</div>';
}
} ?> |
Partager