switch($what) {
// ----------------------------------------------------------------------------------------
case 'NucleusMemberOptions':
- $res = sql_query('SELECT mname as text, mnumber as value FROM '.sql_table('member'));
- while ($o = mysql_fetch_object($res)) {
- echo '<option value="'.Entity::hsc($o->value).'">'.Entity::hsc($o->text).'</option>';
+ $res = DB::getResult('SELECT mname as text, mnumber as value FROM '.sql_table('member'));
+ foreach ( $res as $row )
+ {
+ echo '<option value="'.Entity::hsc($row['value']).'">'.Entity::hsc($row['text']).'</option>';
}
break;
// ----------------------------------------------------------------------------------------