problem show data in EditView.html

[ojalà]

Hi!
I can't print my value in a select in my EditView.html
In EditViwe.php I write:

$focus = new Documents();
$attac = $db->query("SELECT * FROM documents where attachment is null");
while (($focus = $db->fetchByAssoc($attac) ) != null ){
//print_r($focus);
$xtpl->assign("ATTACH", $focus['name']);
}

query is correct, I can see my data, my problem is print this data in my select in EditView.html.
I write:

<select name="name">{ATTACH}</select>

what is wrong?I think problem is about $focus, can you help me?

[vishwasrao]

Hi ,
where this editview.php lies
is it editviewdefs.php in metadata or anything else

[ojalà]

My EditView.php in inside modules (Documents module)

[ojalà]

nobody can hel me??

[dlorenzetti]

Hello,

Try this:

 $attac_options = array();
$focus = new Documents();
$attac = $db->query("SELECT * FROM documents where attachment is null");
while (($focus = $db->fetchByAssoc($attac) ) != null ){
//print_r($focus);
$attac_options[$focus['name']] = $focus['name'];
}
 
$xtpl->assign("ATTACH", get_select_options_with_id($attac_options)); 
  

[andopes]

There is something wrong here:

 $focus = new Documents(); # That is right
$attac = $db->query("SELECT * FROM documents where attachment is null"); # Did you instantiate the $db variable as $db = & PearDatabase::getInstance();???
while (($focus = $db->fetchByAssoc($attac) ) != null ) { # Here you are overloading the just declared $focus. Before it was an object reference, now it is an array.
  //print_r($focus);
  $xtpl->assign("ATTACH", $focus['name']);
}