MySQL选择格式化数据类型问题

I am trying to format a column of Decimals into a currency format for display on a web page -

$query = "SELECT id, year, CONCAT('$', FORMAT(price_avg_sold, 2)), CONCAT('$', FORMAT(price_sqft, 0)), pct_list_sold, adom, sold_nu, sold_chg, year_1, year_2, year_3, year_4, year_5, year_6, year_7, year_8, year_9, year_10
FROM c33062";  
$records_per_page=11;
$newquery = $crud->paging($query,$records_per_page);
$crud->dataview($newquery);
?>
  <tr>
      <td colspan="7" align="center">
  <div class="pagination-wrap">
          <?php $crud->paginglink($query,$records_per_page); ?>
       </div>
      </td>
  </tr>

When I change: price_avg_sold, in my SELECT statement to: CONCAT('$', FORMAT(price_avg_sold, 2)), that column of cells go blank and all others display, so there is no error returned.

I've also tried adding single quotes and same result, blank cells in the column even though there is still data in the cells in phpMyAdmin - FORMAT('price_avg_sold', 2))