An often-used SQL construction is to read a table for a key/value pair. This can be used in creating Select Boxes, Radio groups etc. ADOdb contains a shortcut command getAssoc() to assist in the task.

$sql = "select emp_no, emp_name from employees";
 
$array = $db->getAssoc($sql);
 
print_r($array);
 
/*
* Returns
*/
array(
1000 =>'Joe Smith',
1001 =>'Fred Jones'
1002 => 'Arthur Dent'
);