select from table and add rows.

Hi folks.

In PHP I often do things such as:

$wpartners=array('all'=>'All','sel'=>'Current','mine'=>'Mine');foreach(    loadhash("select p_id as key, p_name as
value                     from partners order by p_name"                 )      as $key=>$dets) {
$wpartners[$key]=$dets;
}

This sets up an array with some pseudo values and then populates it with 
*proper* values from a table.

How's the best way to do this all within SQL. 
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000