$sql="SELECT DISTINCT(area2_code), area2 FROM `cs_mytable`;";
$input['region'] =moscomprofilerHTML::selectList( $list_region, 'region', '', 'area2_code', 'area2', $selected);
$sql="SELECT DISTINCT(area2_code) as 'value', area2 as 'text' FROM `cs_mytable`;";
$input['region'] =moscomprofilerHTML::selectList( $list_region, 'region', '', 'value', 'text', $selected);
Please Log in to join the conversation.
SELECT `area2` AS text, DISTINCT( `area2_code` ) AS value FROM `cs_mytable`
$query = "SELECT `area2` AS text, DISTINCT( `area2_code` ) AS value FROM `cs_mytable`";
$_CB_database->setQuery( $query );
$list_region = $_CB_database->loadObjectList();
Please Log in to join the conversation.
Please Log in to join the conversation.