se/SE/superedit-ID_COSTS_GROUPS.php

<?php


function ID_COSTS_GROUPS( $cmd, $value ) {
	global $result, $thiss;

	if ($cmd == 'POST_VERIFY') {
		return;
	}

	$field_name = 'ID_COSTS_GROUPS';
	$select_list = array();

	$sql = "select `ID`,`S_OTHER_INFO`,`A_STATUS` from `USERS2_OFFERS_COSTS_GROUPS` where `A_STATUS`!='DELETED' order by `ID` ";
	ZAP_SQL( $sql );
	while ($r = mysql_fetch_object( $result )) {
		$select_list [$r->ID] = $r->ID . ": " . $r->S_OTHER_INFO . " (" . $r->A_STATUS . ")";
	}

	echo '<select name="' . $field_name . '">';
		echo ' <option value="">' . " " . '</option>';
		foreach ($select_list as $key => $val) {
			$sel = ($_SESSION[$thiss->DETECT_TABLE_COLUMN]['EDITRECORD'][$field_name] == $key)? ' selected="selected"' : '';
			echo '<option value="' . $key . '"' . $sel . '>' . $val . '</option>';
		}//end foreach
	echo '</select>';
}