OT_Membership

[michael_s]

$mem_query = tep_db_query("select sort_order, ID, CONCAT(membership_name,' ($',membership_fee,')') as membername from " . TABLE_SUBS_MEMBERSHIP_TYPES . " order by sort_order, membership_fee");
while ($mem_values = tep_db_fetch_array($mem_query)) {
$mem_array[] = array('id' => $mem_values['ID'], 'text' => $mem_values['membername']);
}

More...