PHP|Débutant :: Forums

<? php
mysql_select_db($database_CR, $CR);
$query_RsThemes = "SELECT mots FROM Themes_DP ORDER BY mots ASC";
$RsThemes = mysql_query($query_RsThemes, $CR) or die(mysql_error());
$row_RsThemes = mysql_fetch_assoc($RsThemes);
$totalRows_RsThemes = mysql_num_rows($RsThemes);
?>

 <form name="form2" id="form2" method="get" action="themes.php?mots=<?php echo $row_rsCR['mots']; ?>">
        <div align="left">
          <p>Triez par thèmes (Uniquement dans D.P 2010): </p>
          <p>
            <select name="mots" id="mots">
              <?php
do {  
?>
              <option value="<?php echo $row_RsThemes['mots']?>"<?php if (!(strcmp($row_RsThemes['mots'], $row_RsThemes['mots']))) {echo "SELECTED";} ?>><?php echo $row_RsThemes['mots']?></option>
              <?php
} while ($row_RsThemes = mysql_fetch_assoc($RsThemes));
  $rows = mysql_num_rows($RsThemes);
  if($rows > 0) {
      mysql_data_seek($RsThemes, 0);
    $row_RsThemes = mysql_fetch_assoc($RsThemes);
  }
?>
            </select>
</p>
          <p>           </p>
          <p>
            <input type="submit" name="Submit" value="Envoyer" />
          </p>
        </div>
      </form>