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
|
<tr>
<td width="60%" style="font-size:12px">
• Carte graphique :
</td>
<td width="40%"> <select name="listbox_cg" style="width:600px;">
<option name="cg" value="cg" >Aucun(e)</option>
<?php
$req = "select distinct * from products p, products_description pd, products_to_categories p2c, categories_description cd where p.products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and p2c.categories_id = cd.categories_id and cd.categories_id LIKE '1071' order by p.products_price ASC ";
$sql = mysql_query($req);
while ($data = mysql_fetch_assoc($sql))
{
$nom_cg = $data['products_name'];
$prix_cg = round($data['products_price'] * 1.196, 2);
$id_cg = $data['products_id'];
echo "<option value=$id_cg> ".($nom_cg)." - ".($prix_cg)." </option>";
}
?>
</select>
</td>
</tr> |
Partager