ya lo solucione:
<select name="select_idactividad" id="select_idactividad">
<option><Seleccionar></option>
<?php
$cnxString = "host=localhost port=5432 dbname=soft user=supia password=supia";
$dbc = pg_connect ($cnxString);
$consulta = "SELECT idactividad FROM actividad";
if($result = pg_Exec($dbc,$consulta)){
while ($dato = pg_fetch_array($result)){
?>
<option value ="<?php echo $dato['idactividad']; ?>" selected="selected"><?php echo $dato['idactividad']; ?></option>
<?php }
}
?>
</select>
queda asi, gracias a todos!
|