Hi,
I am writing a module to only display unique ICAO aircraft, this is what i have,
/**
* Get an aircraft by unique name
*/
public static function getAircraftByName1() {
$sql = 'SELECT DISTINCT icao, fullname, weight, cruise, maxpax, maxcargo, imagelink, downloadlink
FROM ' . TABLE_PREFIX . 'aircraft
WHERE `enabled` = 1 ';
return DB::get_results($sql);
}
That works fine, but when i try to add the range nothing is displayed so if i do,
/**
* Get an aircraft by unique name
*/
public static function getAircraftByName1() {
$sql = 'SELECT DISTINCT icao, fullname, range, weight, cruise, maxpax, maxcargo, imagelink, downloadlink
FROM ' . TABLE_PREFIX . 'aircraft
WHERE `enabled` = 1 ';
return DB::get_results($sql);
}
Not sure why but any help would be appreciated
Thanks.