- trim: documentation ( source)
<?php
$sql = "select ex.opening_minutes as opening, asset.assetID, ex.google_code as exch_google_code, asset.google_code as asset_google_code from selected_asset as sa".
" inner join asset on asset.assetID = sa.assetID".
" inner join asset_exchange ae on ae.assetID = sa.assetID".
" inner join exchange as ex on ex.exchangeID = ae.exchangeID".
" where ae.exchangeID = ".$exchangeID." and sa.brokerID = ".$brokerID;
$extension = "";
$asset_google_code = $rec["asset_google_code"];
$exchange_google_code = $rec["exch_google_code"];
$assetentry = array ( $rec["assetID"] => $asset_google_code );
$this->assets[] = $assetentry;
$extension .= trim($exchange_google_code) .":".$asset_google_code.",";
//$extension = rtrim($extension, ",");
$extension .= "'";
$sql = "select ex.opening_minutes as opening from exchange as ex where ex.exchangeID = ".$exchangeID;