OOH Forms and SQL bucle

[Víctor Berga]

Hi guys!

First, I'm sorry for my english. I don't speak it.

Well, I have the next code:

echo "<select name=\"localidad\" size=\"1\" id=\"localidad\">
          <option value=\"0\" selected>Seleccione...</option>";

      $query = "SELECT * FROM localidades WHERE id='$localidad'";
      $db->query($query);

      while ($db->next_record()){
        $id = $db->f("id");
        $localidad = $db->f("localidad");
        echo "<option value=\"$id\" selected>$localidad</option>";
      }

And I would like migrate to OOH Forms, but the while() in select I don't know migrate. For exameple, I tried next:

$query = "SELECT * FROM localidades WHERE id='$localidad'";

$db->query($query);

while ($db->next_record()){
          $id = $db->f("id");
      $nombre = $db->f("nombre");
      $lista .= array("label"=>$nombre,"value"=>$id);
    }

    $o = array($lista);
    $f->add_element(array("type"=>"select",
                          "name"=>"tipo_doc",
                          "options"=>$o,
                          "size"=>1,));

In the man of phplib $o is declared:

$o = array(array("label"=>"Please Select","value"=>0),
                   array("label"=>"Apple","value"=>1),
                   array("label"=>"Orange","value"=>2),
                   array("label"=>"Pear","value"=>3),
                   array("label"=>"Grape","value"=>4));

I need a query to DB for my select.
Please help me.

Best Regars,
Victor

[Layne Weathers]

Your second code segment is trying to concatenate arrays to a string variable. You need to do something like this:

$o = array();

while ($db->next_record()){
$id = $db->f("id");
$nombre = $db->f("nombre");
$o[] = array("label"=>$nombre,"value"=>$id);
}

$f->add_element(array("type"=>"select",
"name"=>"tipo_doc",
"options"=>$o,
"size"=>1,));

[Víctor Berga]

Thanks! Thanks!

You are my God! ;-)

Bye,