Add sort price description

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
4 years 2 days ago #325207

Hi,

You need to use the round function of MySQL :
www.w3schools.com/sql/func_mysql_round.asp
So instead of:
concat(product.product_description,'$',product.product_sort_price)
you could use:
concat(product.product_description,'$',round(product.product_sort_price,2))

Please Log in or Create an account to join the conversation.

  • Posts: 192
  • Thank you received: 15
  • Hikashop Business
4 years 1 day ago #325254

That worked perfectly! I'd count this as solved for us.

Thanks,
Ian and Stu

The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds
Powered by Kunena Forum