select dinamica...

[freetom]

MI spiego meglio ho un form con la seguente select..

<select name="select">
<option selected>- Choose One -</option>
<option>- january -</option>
<option>- febrary -</option>
<option>- march -</option>
<option>- avril -</option>
<option>- may -</option>
<option>- june -</option>
<option>- july -</option>
<option>- august -</option>
<option>- september -</option>
<option>- november -</option>
<option>- december -</option>
</select>


Avendo una tabella mysql con i campi MESE e OCCUPATO vorrei rendere il tutto dinamico con php mostrando nella select solo i mesi non occupati...oppure meglio mostrando accanto ai nomi dei mesi occupati la scritta NOT AVAILABLE


Come posso fare?

thanks

[piero.mac]

    <select name="select">
    <option selected>- Choose One -</option>
<?
$query = "SELECT * FROM tabella order by id";
$res = mysql_query($query) or die (mysql_error());

while($row = mysql_fetch_assoc($res))  {

echo "
     <option>$row[mese] - $row[occupato]</option>
     ";
}
?>
   </select>

[freetom]

Lo provo subito

[freetom]

Pekke non funge???

this is may cod...


<select name="period">
<option selected>- Choose One -</option>
<?
$query = "SELECT * FROM reservations order by id";
$res = mysql_query($query) or die (mysql_error());

while($row = mysql_fetch_assoc($res)) {

echo "<option>$row[mese] - $row[occupato]</option>";
}
?>
<option>- january (1° week) -</option>
<option>- january (2° week) -</option>
<option>- january (3° week) -</option>
<option>- january (4° week) -</option>
<option>- febrary (1° week) -</option>
<option>- febrary (2° week) -</option>
<option>- febrary (3° week) -</option>
<option>- febrary (4° week) -</option>
<option>- march (1° week) -</option>
<option>- march (2° week) -</option>
<option>- march (3° week) -</option>
<option>- march (4° week) -</option>
<option>- avril (1° week) -</option>
<option>- avril (2° week) -</option>
<option>- avril (3° week) -</option>
<option>- avril (4° week) -</option>
<option>- may (1° week) -</option>
<option>- may (2° week) -</option>
<option>- may (3° week) -</option>
<option>- may (4° week) -</option>
<option>- june (1° week) -</option>
<option>- june (2° week) -</option>
<option>- june (3° week) -</option>
<option>- june (4° week) -</option>
<option>- july (1° week) -</option>
<option>- july (2° week) -</option>
<option>- july (1° week) -</option>
<option>- august (1° week) -</option>
<option>- august (2° week) -</option>
<option>- august (3° week) -</option>
<option>- august (4° week) -</option>
<option>- september (1° week) -</option>
<option>- september (2° week) -</option>
<option>- september (3° week) -</option>
<option>- september (4° week) -</option>
<option>- november (1° week) -</option>
<option>- november (2° week) -</option>
<option>- november (3° week) -</option>
<option>- november (4° week) -</option>
<option>- december (1° week) -</option>
<option>- december (2° week) -</option>
<option>- december (3° week) -</option>
<option>- december (4° week) -</option>
</select>
<?
//spazio per ulteriore aggiunta in php...
?>


Risultato?

Mi fa vedere solo Choose One... non considerandomi piu' affatto il resto della pagina

Dove fagiano???

Thanks

[pinopisc]

forse la query non ha effetto.
Controlla l' esito.