Code : Tout sélectionner
<?php
mysql_connect('*', '*', '*') or die('Erreur de connexion');
mysql_select_db('galc') or die('Base inexistante');
$sql = 'SELECT * FROM ann_tbl GROUP BY Ct';
$query = mysql_query($sql) or die( 'Erreur' );
$nb = mysql_num_rows($query);
while ( $list = mysql_fetch_array( $query ) ) {
echo '<option value="'.$list['Ct'].'">'.$list['categorie'].'</option>';
}
mysql_close();
?>
Merci !
Code : Tout sélectionner
<form name="form" method="post" action="index.php?page=annonce&action=post">
<select name="liste">
<?php
mysql_connect('*', '*', '*') or die('Erreur de connexion');
mysql_select_db('galc') or die('Base inexistante');
$sql = 'SELECT * FROM ann_tbl GROUP BY Ct';
$query = mysql_query($sql) or die( 'Erreur' );
$nb = mysql_num_rows($query);
while ( $list = mysql_fetch_array( $query ) ) {
echo '<option value="'.$list['Ct'].'">'.$list['categorie'].'</option>';
}
mysql_close();
?>
</select>
<input type="submit" name="Submit" value="Envoyer">
</form>
Code : Tout sélectionner
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>::: GALC - Racing :::</title>
<link rel="STYLESHEET" href="styles.css" type="text/css" />
<style type="text/css">
<!--
.Style1 { font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
color: #000000;
}
body {
background-image: url(images/back.gif);
background-color: #33CC66;
}
-->
</style>
</head>
<body>
<div id="pageWrapper">
<div id="top"><img src="images/logo.jpg" width="247" height="88" alt="logo" />
</div>
<div id="header">
</div>
<div id="contentWrappper">
<div class="bar">
<a href="index.php?page=accueil">Accueil</a>
<a href="index.php?page=accueil">Article</a>
<a href="index.php?page=annonce">Annonces</a>
<a href="index.php?page=accueil">Liens</a>
<a href="index.php?page=accueil">Contact</a></div>
<div id="urightColumn"> <h1>
<h1>Section annonces ,</h1>
<p>Ici, vous trouverez les annonces d'article que GALC racing vous propose ! </p>
<form name="form" method="post" action="index.php?page=annonce&action=post">
<select name="liste">
<option value="Pn">Pneus</option><option value="Pt">Pot</option><option value="Rs">Reservoir</option></select>
<input type="submit" name="Submit" value="Envoyer">
</form>
</h1>
</div>
<div id="lleftColumn"> <h1> News... </h1>
<p>
<p><font face="verdana" size="2">• <a href="index.php?page=accueil">Test php</a> 2005-08-10</font></p><p><font face="verdana" size="2">• <a href="index.php?page=accueil">Testt</a> 2005-08-07</font></p><p><font face="verdana" size="2">• <a href="index.php?page=accueil">test</a> 2005-08-07</font></p><p><font face="verdana" size="2">• <a href="index.php?page=accueil">Test de texte</a> 2005-08-03</font></p><p><font face="verdana" size="2">• <a href="index.php?page=accueil">Test de texte</a> 2005-08-03</font></p>
</p>
</div>
</div>
</div>
<div id="footer">
GALC - Racing © 2005
</div>
</body>
</html>
