select ciego

[jegggf]

buenas necesito agregarle un name a un select,



<?php

include("conecta.php");

global $db_selected;
global $db;



//echo "<select > \n"; //name= "objetos[]"
function obj($result){

$result = mysql_query("SELECT objetos FROM prueba1", $db);
while ($row = mysql_fetch_row($result))
{
echo "<option>$row[0]</option> ";
}
}
//echo "</select> \n";
?><select name="objetos" value="<?php obj($result); ?>"></select>
<?php
$result1 = mysql_query("SELECT lugares FROM prueba2", $db);

echo "<select > \n"; //name="lugares[]"

while ($row = mysql_fetch_row($result1)){
echo "<option>$row[0]</option> ";
}
echo "</select> \n";

?>



he probado esto pero no me deja, lo logico seria:

<?php

include("conecta.php");

global $db_selected;
global $db;
//$usertable = 'prueba1';

$result = mysql_query("SELECT objetos FROM prueba1", $db);

echo "<select > \n"; //name= "objetos[]"

while ($row = mysql_fetch_row($result)){
echo "<option>$row[0]</option> ";
}
echo "</select> \n";

$result1 = mysql_query("SELECT lugares FROM prueba2", $db);

echo "<select > \n"; //name="lugares[]"

while ($row = mysql_fetch_row($result1)){
echo "<option>$row[0]</option> ";
}
echo "</select> \n";

?>


ahi trae los resultados pero me queda ciego y no me deja asignarle otra funcion, desde ya muchas gracias.